Multiple choice technology databases

Does the view exist if the table is dropped from the database?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When a base table is dropped from the database, views that reference that table become invalid and cease to function properly. The view object definition may still exist in the data dictionary, but the view is not usable. The statement 'Does the view exist' is asking about usability - a view dependent on a dropped table does not exist as a functional object. The claimed answer (B - False) is correct.