Which condition must be true in order that a view is considered updateable?
Posted: Sun Jun 11, 2023 4:01 pm
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.
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.