Quiz 1z0-117

Quiz 1z0-117, Oracle Database 11g Release 2: SQL Tuning

What are true about the execution of the query?

Which statement is true about the usage of these hints in the query?

Which statement is true?

What is the effect of changing the value of the parameter?

Which two statements are true about the query execution?

How can you reduce fragmentation of an index without affecting the current transactions that are using the index?

Which query transformation technique is used by the optimizer?

Which two actions might improve the performance of the query?

which two cases will the degree of parallelism be automatically calculated?

What would you use to view the tracing information?