13.8. Review Questions

  1. Which data dictionary view provides the recommended action, as a SQL statement, from the Segment Advisor?

    1. DBA_ADVISOR_FINDINGS

    2. DBA_ADVISOR_RECOMMENDATIONS

    3. DBA_ADVISOR_ACTIONS

    4. DBA_ADVISOR_RATIONALE

  2. Which of the following statements is not true about sorted hash clusters?

    1. The new access path is used regardless of the type of predicate in the WHERE clause.

    2. You are allowed to create indexes on sorted hash clusters.

    3. The cost-based optimizer must be used to take advantage of the new access path.

    4. Additional sorts are not necessary if you access the cluster by one of the lists of hash key columns.

    5. More than one table can be stored in a sorted hash cluster.

  3. Consider the following scenario. The user SCOTT runs a query at 8:25 A.M. that receives ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.