Basic Oracle Concepts and Programming Question:
Download Questions PDF

Can You Drop an Index Associated with a Unique or Primary Key Constraint?

Answer:

You can not delete the index associated with a unique or primary key constraint. If you try, you will get an error like this: ORA-02429: cannot drop index used for enforcement of unique/primary key.

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Drop an Index?What Happens to Indexes If You Drop a Table?