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 in USER_IND_COLUMNS identify the indexed column name and its position within the index?
Please select all the correct answers.
  A. COLUMN_NAME
  B. COLUMN_POSITION
  C. INDEX_TYPE
  D. UNIQUENESS