SQL View Management 2

Question 1

Which clause prevents an INSERT or UPDATE through a view from producing rows that the view itself cannot select?

Accepted Answer

WITH CHECK OPTION

Answer

WITH CHECK OPTION enforces that modified rows still satisfy the view's WHERE condition.

Question 2

What does CREATE OR REPLACE VIEW do if the view already exists?

Accepted Answer

Redefines the existing view

Answer

CREATE OR REPLACE VIEW redefines the view in place without dropping it first.

Question 3

A view defined as SELECT col FROM t WHERE x > 5 is generally updatable only if it references how many base tables?

Accepted Answer

One

Answer

Simple updatable views typically map to a single underlying base table.

Question 4

Which statement removes a view named sales_summary?

Accepted Answer

DROP VIEW sales_summary

Answer

DROP VIEW deletes the view definition from the database.

Question 5

What happens to the data in base tables when a view is dropped?

Accepted Answer

It remains unchanged

Answer

Dropping a view removes only the stored query, not the underlying data.

SQL Practice Test