Multiple choice technology databases

Dropping of table has which of the following effects on the non unique index created on the table

  1. no effect

  2. The Index will be dropped

  3. The index will become unusable

  4. the index will have NULLvalues

  5. You cannot drop a table until you drop the index
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When a table is dropped, all associated indexes including non-unique ones are automatically dropped. Oracle cannot maintain an index on a non-existent table. The indexes are cleaned up as part of the DROP TABLE operation.

Keep practicing — related questions