1z0-060 Oracle Exam Questions and Free Practice Test

Question 31

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message

B. The rows in the table are truncated without being archive

C. The rows in the table are archived, and then truncate

D. The rows in both the table and the archive are truncate

Correct Answer:C

Question 32

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?

A. Bind Variable Peeking

B. SQL Plan Baselines

C. Adaptive Cursor Sharing

D. Bind variable used in a SQL statement

E. Literals in a SQL statement

Correct Answer:ACE

Question 33

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?

A. Increasing the priority of the job class to which the job belongs

B. Increasing the job's relative priority within the Job class to which it belongs

C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

F. Increasing the priority of the scheduler window to which the job belongs

Correct Answer:CF

Question 34

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

A. Setting a metric threshold

B. Implementing Database Resource Manager

C. Enabling resumable timeout for user sessions

D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Correct Answer:D

START 1z0-060 EXAM