A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?
A) PRIMARY KEY
B) WITH CHECK OPTION
C) UNIQUE
D) all of the above

Question

A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?​
A) ​PRIMARY KEY
B) ​WITH CHECK OPTION
C) ​UNIQUE
D) ​all of the above

Quizplus · Accepted Answer

DML operations on a simple view can be performed as long as they do not violate any existing constraints on the underlying base table, including PRIMARY KEY, WITH CHECK OPTION, and UNIQUE constraints.

A User Can Perform a DML Operation (Add,modify,delete)on a Simple