SQL views are always updateable when ________.
A)the view is based on a single table with no computed columns,and all non-null columns are present in the view
B)the view is based on any number of tables,with or without computed columns,and the INSTEAD OF trigger is defined for the view
C)the view is based on multiple tables,the update is being done on the most subordinate table,and the rows of that table can be uniquely identified
D)A and B
E)A,B and C

Question

Quizplus · Accepted Answer

SQL views are updateable only when they meet the criteria mentioned in option A (single table with no computed columns and all non-null columns present) or when an INSTEAD OF trigger is defined for the view, as mentioned in option B. Option C is partially correct, as views can be updatable when based on multiple tables, but only if the update is being done on the most subordinate table and the rows can be uniquely identified. Therefore, the best choice is D, as it covers all the possible scenarios for an updateable view.

SQL Views Are Always Updateable When ________