SQL views are always updatable 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

Option A specifies the condition for a single table view to be updatable, and Option B specifies the condition for any view to be updatable using an INSTEAD OF trigger. Therefore, when both conditions are satisfied, i.e., when the view is based on one or more tables and an INSTEAD OF trigger is defined, the view is always updatable. Option C is not valid in all cases, as the update must be done on the most subordinate table and the rows of that table must be uniquely identified, which may not always be possible. Hence, the correct choice is D.

SQL Views Are Always Updatable When ________