Quiz 1z0-117

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

Which are the two prerequisites for enabling star transformation on queries?

What four changes could you make to help avoid the error and ensure that the query executes in parallel?

Which three statements are true regarding the execution plan?

Which three statements are correct?

Which two types of recommendations can be provided by the SQL Tuning Advisor?

Which type of SQL statement would be selected for tuning by the automatic SQL framework?

Which three statements are true about these settings if no hints are used in a SQL statement?

Which statement is true about the execution plan?

Which two types of SQL statements will benefit from dynamic sampling?