> > Oracle MCQs > Managing Indexes MCQs

Managing Indexes MCQ

1. An index can be created ____.

implicitly

Explicitly

Only at instance startup

both a and b

Answer

Correct Answer: implicitly

Note: This Question is unanswered, help us to find answer for this one

2. To use a function-based index?

None

The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes

The table must be analyzed after the index is created

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?

Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint

Specify a new index that the database is to use to enforce the constraint

None

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?

Space is saved in the redo log files

Performance improves for parallel creation of large indexes

All

The time it takes to create the index is decreased

Answer

Correct Answer: All

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?

Primary

None

Primary And Unique

UNIQUE

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?

False

True

Answer

Correct Answer: False

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?

False

True

Answer

Correct Answer: True

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?

False

True

Answer

Correct Answer: True

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?

The table or cluster to be indexed is in another schema

None

You don’t have INDEX privilege on the table to be indexed

You have CREATE ANY INDEX system privilege

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?

True

False

Answer

Correct Answer: True

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?

Coalesce Index

Rebuild Index

Rebuild Index And Coalesce Index

None

Answer

Correct Answer: Coalesce Index

Note: This Question is unanswered, help us to find answer for this one

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs