Which condition must be true in order that a view is considered updateable?

Which condition must be true in order that a view is considered updateable?

Which condition must be true in order that a view is considered updateable?

A.
The user must have the UPDATE or DELETE privilege for the underlying table.

B.
There must be a subquery in the WHERE clause that refers to a table in the FROM
clause.

C.
There must be a one-to-one relationship between the rows in the view and the rows in the
underlying table.

D.
The view must only refer to literal values.

Explanation:
Reference:
http://dev.mysql.com/doc/refman/5.0/en/view-updatability.html (first para)

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Jay

Jay

C
From MySQL 5.0 Certification Study Guide by Dubois, Hinz, and Pedersen:
“The primary conditions for updatability are that there must be a one-to-one relationship between the rows in the view and the rows in the base table…”

Reply