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 Question | Next Question |
How To Drop an Index? | What Happens to Indexes If You Drop a Table? |