Managing Indexes MCQ
1. An index can be created ____.
Answer
Correct Answer:
implicitly
Note: This Question is unanswered, help us to find answer for this one
2. To use a function-based index?
Answer
Correct Answer:
The table must be analyzed after the index is created
Note: This Question is unanswered, help us to find answer for this one
3. If you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints, the database lets you?
Answer
Correct Answer:
Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint
Note: This Question is unanswered, help us to find answer for this one
4. Creating an index with NOLOGGING has which of these benefits?
Note: This Question is unanswered, help us to find answer for this one
5. Which key automatically have indexes, but you might want to create an index on a foreign key?
Answer
Correct Answer:
Primary And Unique
Note: This Question is unanswered, help us to find answer for this one
6. CREATE INDEX does not stores the timestamp of the most recent function used in the function-based index?
Note: This Question is unanswered, help us to find answer for this one
7. Creating an index using key compression enables you to eliminate repeated occurrences of key column prefix values?
Note: This Question is unanswered, help us to find answer for this one
8. Because indexes created using NOLOGGING are not archived, perform a backup after you create the index?
Note: This Question is unanswered, help us to find answer for this one
9. To create an index in your own schema, give the following conditions which is true?
Answer
Correct Answer:
You have CREATE ANY INDEX system privilege
Note: This Question is unanswered, help us to find answer for this one
10. If a table is dropped, all associated indexes are dropped automatically?
Note: This Question is unanswered, help us to find answer for this one
11. While Consider Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space?
Answer
Correct Answer:
Coalesce Index
Note: This Question is unanswered, help us to find answer for this one