Which of the following statements about performing DML operations on complex views is correct?
A) DML operations cannot be performed on a non primary key-locked table
B) DML operations cannot be performed on a non key-preserved table.
C) DML operations can be performed if a view contains a group function or a GROUP BY clause.
D) none of the above

Question

Which of the following statements about performing DML operations on complex views is correct?​
A) ​DML operations cannot be performed on a non primary key-locked table
B) ​DML operations cannot be performed on a non key-preserved table.
C) ​DML operations can be performed if a view contains a group function or a GROUP BY clause.
D) ​none of the above

Quizplus · Accepted Answer

When performing DML operations on complex views, it is important to ensure that the view is key-preserved, meaning that the view's primary key columns are present in the underlying table and cannot be changed through the view. If the view is not key-preserved, then DML operations may result in errors or unexpected results. Option A is incorrect because primary key locking is not relevant to the ability to perform DML operations on a table. Option C is also incorrect because the presence of group functions or a GROUP BY clause does not impact the ability to perform DML operations on a view.

Which of the Following Statements About Performing DML Operations on Complex