Partitioned Tables   «Prev  Next»

Oracle Global Indexes - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following types of partitioned indexes does Oracle support?
Please select all the correct answers.
  A. Local prefixed indexes
  B. Local non-prefixed unique indexes
  C. Global prefixed indexes
  D. Global non-prefixed indexes

2. What is the minimum syntax required to define a local index in Oracle?
Please select the best answer.
  A. LOCAL
  B. LOCAL PARTITION BY RANGE (col_name)
  C. GLOBAL PARTITION BY RANGE (col_name)
  D. (PARTITION VALUES LESS THAN value)
  E. LOCAL (PARTITION p1 TABLESPACE ts1, PARTITION p2 TABLESPACE ts2)
  F. (PARTITION TABLESPACE tablespace_name)

3. Which of the following syntax options are not allowed when you are defining an individual partition within a table's partition list?
Please select all the correct answers.
  A. PARTITION BY RANGE
  B. VALUES LESS THAN
  C. TABLESPACE tablespace_name
  D. MAXVALUE

4. Which of the following statements about Oracle global indexes are true?
Please select all the correct answers.
  A. The partitions of a global index must align one-to-one with the partitions of the underlying table.
  B. A global index can be created on a partitioned table without the index itself being partitioned.
  C. A local index always outperforms a global index for OLTP workloads.
  D. A global partitioned index can use range or hash partitioning.

5. If you create an index on a partitioned table without specifying either LOCAL or GLOBAL, what do you get?
Please select the best answer.
  A. A local index, automatically partitioned to match the table
  B. An error — Oracle requires one of the two keywords to be specified
  C. A global, non-partitioned index
  D. A global index, automatically partitioned to match the table

6. Which of the following table partition operations can mark a global index (or global index partition) UNUSABLE, unless you specify an index-maintenance clause such as UPDATE INDEXES?
Please select all the correct answers.
  A. Adding a new, empty partition to the table
  B. Truncating a partition
  C. Dropping a partition
  D. Exchanging a partition