Multiple choice technology databases

If the base table of a view is deleted and we give SQL Select command on view table name

  1. Gives the columns referred in select statement of view

  2. Reports a error

  3. Select only particular columns of view table

  4. Outputs the whole view table
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A view is a virtual table that dynamically retrieves data from its base table. If the underlying base table is dropped or deleted, the view becomes invalid. Subsequent query attempts on the view will fail and report an error since the source data structure no longer exists.

Keep practicing — related questions