Multiple choice technology databases

If a table is dropped, which of the following statement is true.

  1. indexes and sequences are automatically dropped, but views and constraints remain

  2. views and indexes are automatically dropped, but constraints and sequences remain

  3. indexes and constraints are automatically dropped, but views and sequences remain

  4. views and sequences are automatically dropped, but indexes and constraints remain
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a table is dropped, the indexes and constraints associated with that table are automatically dropped. Views and sequences are independent objects and remain intact even after dropping the table.

Keep practicing — related questions