Which of the following statements about complex views is incorrect?
A) It is created with the same CREATE VIEW command as a simple view.
B) It retrieves or derives data from one or more tables.
C) All DML operations can be performed on complex views,just like simple views.
D) It may contain functions or grouped data.

Question

Which of the following statements about complex views is incorrect?​
A) ​It is created with the same CREATE VIEW command as a simple view.
B) ​It retrieves or derives data from one or more tables.
C) ​All DML operations can be performed on complex views,just like simple views.
D) ​It may contain functions or grouped data.

Quizplus · Accepted Answer

Complex views, especially those involving joins, functions, or groupings, often do not support all DML operations (such as INSERT, UPDATE, DELETE) directly due to the complexity of mapping changes back to the underlying tables.

Which of the Following Statements About Complex Views Is Incorrect?​

Which of the Following Statements About Complex Views Is Incorrect?