Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q21: Which SQL keyword is used to name
Q22: Referential integrity constraints are implemented in SQL
Q23: The SQL keyword CONSTRAINT is used to
Q24: If the table PRODUCT has a column
Q25: Rows can be removed from a table
Q27: Based on the table below,a function to
Q28: The SQL keyword MODIFY is used to
Q29: If you have a foreign key in
Q30: SQL views are not used _.<br>A)to hide
Q31: If the values in an SQL view