Multiple choice technology web technology

You have dropped a table from where a VIEW was created . What would be the status of that VIEW

  1. View dropped also

  2. View becomes invalid

  3. View remains as it is

  4. View is accessible
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When a base table is dropped, any dependent view becomes invalid because its underlying schema no longer exists. The view object isn't automatically dropped (it remains in metadata with an INVALID status). Attempts to query the invalid view will fail. The view must be recreated or the table restored to make it functional again.

Keep practicing — related questions