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)Both A and B are correct

Question

Quizplus · Accepted Answer

Views are updatable under specific conditions. When a view is based on a single table, includes all non-null columns, and has no computed columns, it can be directly updated. Additionally, views based on multiple tables or with computed columns can be made updatable through the use of INSTEAD OF triggers, which provide custom update logic. Therefore, both conditions A and B allow for an updatable view.

SQL Views Are Always Updatable When ________