Question: Which of the following is not true about indexes?

Options

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.

Click to view Correct Answer

Previous || Next

Managing Databases with Oracle - General Questions more questions

Relations are:

What type of failure occurs when Oracle fails due to....

Which statement about sequences is not true?

Which prefixes are available to Oracle triggers?

In creating a procedure, you may get a message if....

Which of the following is not true of SQL views?

SQL*Plus will finish the statement and execute it when the....

Which of the following is NOT an Oracle-supported trigger?

After a table has been created, its structure can be....

Which of the following is not true about modifying table....

Advanced SQL - General Questions more Online Exam Quiz

Distributed Databases - General Questions

Introduction to Database - General Questions

Introduction to SQL - General Questions

JDBC, Java Server Pages, and MySQL - General Questions

Logical Database Design - General Questions

SQL Server 2000 - General Questions

Managing Multiuser Databases - General Questions

Modeling Data in the Organization - General Questions

Object-Oriented Database - General Questions

Object-Oriented Data Modeling - General Questions