Oracle database automatically creates an index for the primary key of a table and for columns included in a unique constraint.

Options
- True
- False

CORRECT ANSWER : True

Discussion Board
INDEX

The above statement is true. Oracle database automatically creates an index for the primary key of a table and for columns included in a unique constraint. When a unique or primary key constraint is enabled, Oracle Database creates an index automatically, but Oracle recommends that you create these indexes explicitly. If you want to use an index with a foreign key constraint, then you must create the index explicitly.

Prajakta Pandit 02-15-2017 12:14 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲