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


Correct Option: B

Find more quizzes: