Quiz 1z0-117

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

Which two recommendations can you get?

Use the tkprof utility to convert the trace files into formatted output.

What are the two possible causes?

Which two options are true about the execution plan and the set of statements?

What are three common reasons for SQL statements to perform poorly?

What are two possible reasons for the optimizer to use full table scans instead of index unique scans and index range scans?

Which two statements are correct about the execution of the command?

What will be the effect of executing this procedure?

Which two are true about parallel statement queuing when this plan is active?

What should you do to improve the performance of the query?