Quiz 1z0-117, Oracle Database 11g Release 2: SQL Tuning
Which two are true regarding the execution plan?
Which two tasks are performed during the optimization stage of a SQL statement?
Which statement is true regarding the execution of the query?
Which task would you perform to achieve this?
What is the correct method of consolidating the trace files generated by the procedure?
Which statement is true about an automatic SQL task?
Which two are true concerning the execution plan?
Which two methods can you use to reduce hard parsing?
Which two options might help to avoid the performance degradation of the queries?
Identify the two correct interpretations that can be made from the execution plan.