Index Enhancements   «Prev  Next»

Oracle Index Enhancements - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Why would you create a domain index?
Please select all the correct answers.
  A. To handle unusual data types, such as spatial data or video clips
  B. To replace an existing Oracle comparison operator
  C. To create a new comparison operator
  D. To add a rule to the rule-based optimizer

2. In which of these commands can you use the new ONLINE parameter?
Please select all the correct answers.
  A. CREATE TABLE
  B. CREATE INDEX
  C. ALTER INDEX
  D. ANALYZE

3. When is a function-based index used?
Please select the best answer.
  A. Whenever its associated table is accessed
  B. Whenever a SQL statement uses the function in its WHERE clause
  C. Whenever a SQL statement uses the function in its WHERE clause while accessing the table the index is associated with
  D. Whenever the rule-based optimizer determines it should be used