Loading Consent Dialog

Partitioned Tables   «Prev  Next»

Oracle Global Indexes - Quiz

Local and Global Partitioning

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 syntax is required in defining a local index?
Please select the best answer.
  A. LOCAL
  B. LOCAL PARTITION BY RANGE (col_name)
  C. LOCAL
  D. (PARTITION VALUES LESS THAN value)
  E. LOCAL
  F. (PARTITION TABLESPACE tablespace_name)

3. Which of the following syntax options are not allowed when you are defining specific partitions for a table?
Please select all the correct answers.
  A. PARTITION BY RANGE
  B. VALUES LESS THAN
  C. TABLESPACE tablespace_name
  D. MAXVALUE