Online Access Free 1z1-062 Practice Test

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

• A.A large number COMMITS are being performed.
• B.Cursors are not being shared.
• C.The size of the shared pool is too small.
• D.There are frequent logons and logoffs.
• E.The buffers are being read into the buffer cache, but some other session is changing the buffers.

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

• A.Gather dictionary statistics
• B.Recompile all invalid objects
• C.Put all readonly tablespaces in read write mode
• D.Set the compatible parameter to 12.1.0.1
• E.Empty all user recycle bins

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? (Choose two.)

• A.Increasing the priority of the scheduler window to which the job belongs
• B.Moving the job to an existing higher priority scheduler window with the same schedule and duration
• C.Increasing the value of the JOB_QUEUE_PROCESSES parameter
• D.Increasing the priority of the job class to which the job belongs
• E.Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• F.Increasing the job's relative priority within the Job class to which it belongs

Which two statements are true about standard database auditing? (Choose two.)

• A.Operations by the users logged on as SYSDBA cannot be audited.
• B.Statements that refer to standalone procedure can be audited.
• C.DDL statements can be audited.
• D.Only one audit record is ever created for a session per audited statement even though it is executed more than once.

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

Which two are true? (Choose two.)

• A.PCTFREE eliminates row chaining during inserts
• B.80% of every data block in daily_ords_list is reserved for row inserts
• C.PCTFREE can help reduce row migration during updates
• D.PCTFREE can help to minimize row chaining during inserts
• E.20% of each data block in the table is reserved for row updates