Quiz 1z0-117

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

What would you do to influence the optimizer for better selectivity?

Which three are tasks performed in the hard parse stage of a SQL statement executions?

Which action would you like to make the query use the best plan for the selectivity?

Which two are the fastest methods for fetching a single row from a table based on an equality predicate?

Which two methods can you use to view the required execution plan?

Which statement is true about an SQL plan baselines that are fixed?

What can be the two reasons for full table scan?

Which four must be true to enable sessions to benefit from improved response time made possible by these materialized views?

Which three statements are true about the execution of this query?

Which two statements are true about the query execution?