Index Organized  «Prev  Next»

Index Organized Tables - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following modifications can you make on an existing index-organized table with the ALTER TABLE command?
Please select all the correct answers.
  A. Add columns.
  B. Reorganize the table.
  C. Modify the storage characteristics of the table.
  D. Modify the physical characteristics of the overflow segment for the table.

2. Which of the following is not a syntax option for creating an overflow segment for an index-organized table?
Please select the best answer.
  A. PCTTHRESHOLD
  B. OVERFLOW TABLESPACE tablespace
  C. ADD OVERFLOW
  D. INCLUDING column_name

3. If the leaf nodes on one side of an index-organized table become less populated than the leaf nodes on the other side of the table because of usage, you should
Please select the best answer.
  A. Allocate an overflow tablespace for the index-organized table
  B. Rebuild the table with the ALTER TABLE REBUILD command
  C. Rebuild the table with a four-step process
  D. Do nothing