Explicit control over indexes - UNIQUE & PRIMARY KEY constraints - Oracle Indexes and Partitioned Tables

Q.  What does the database let you do if you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints?
- Published on 04 Aug 15

a. Specify a new index that the database is to use to enforce the constraint
b. Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint
c. Both A & B
d. None of the above

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

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - If you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints, the database lets you:

    - Specify an existing index that the database is to use to enforce the constraint

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

    - These options are specified using the USING INDEX clause.

Post your comment / Share knowledge


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