Quiz 1Z0-053, Oracle Database 11g: Administration II
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
What two statements are true regarding the recommendations received from the SQL Access Advisor?
Arrange the steps required in the correct sequence to accomplish this task on the test machine.
Which two prerequisites are needed for performing workload capture and replay?
Which action would you take before performing this task?
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?
What would you do with these SQL statements?
Which two operations are performed by the optimizer in this scenario?
Which two statements about Oracle Direct Network File System (NFS) are true?