Managing Indexes MCQ

1. An index can be created ____.

2. To use a function-based index?

3. If you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints, the database lets you?

4. Creating an index with NOLOGGING has which of these benefits?

5. Which key automatically have indexes, but you might want to create an index on a foreign key?

6. CREATE INDEX does not stores the timestamp of the most recent function used in the function-based index?

7. Creating an index using key compression enables you to eliminate repeated occurrences of key column prefix values?

8. Because indexes created using NOLOGGING are not archived, perform a backup after you create the index?

9. To create an index in your own schema, give the following conditions which is true?

10. If a table is dropped, all associated indexes are dropped automatically?

11. While Consider Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space?