RelationalDBDesign RelationalDBDesign


Oracle Indexes   «Prev  Next»

Altering indexes - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which data dictionary view does not contain information about indexes?
Please select the best answer.
  A. USER_INDEXES
  B. USER_COLUMNS
  C. USER_IND_COLUMNS
  D. USER_PART_INDEXES

2. When you drop an index, it:
Please select all the correct answers.
  A. Drops all the data in the index from the associated tables in the database
  B. Gives the index blocks back to the tablespace that contained the index
  C. Drops only the data in the index structure
  D. Never affects database performance

3. Which two columns identify the columns in an index, not attributes of the index?
Please select all the correct answers.
  A. TABLE_NAME
  B. INDEX_TYPE
  C. UNIQUENESS
  D. INDEX_NAME