Managing Databases with Oracle - Technical MCQs

Q1:

Which of the following is not true about indexes?

A Indexes are created to enforce uniqueness on columns.

B Indexes are created to enable fast retrieval by column values.

C Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

D Indexes are created with the ALTER TABLE command.

ANS:D - Indexes are created with the ALTER TABLE command.

No answer description is available.