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) A and B
E) A,B,and C
Correct Answer:

Verified
Correct Answer:
Verified
Q4: To set a column value to an
Q8: The SQL keyword CONSTRAINT is used to
Q9: The following database will be used in
Q19: The SQL keyword CHECK is used to
Q46: The SQL keyword CONSTRAINT is used to
Q61: SQL triggers are used for providing default
Q67: If a trigger is being written to
Q77: Because SQL statements are table-oriented,whereas programs are
Q78: The SQL CREATE TABLE statement is used
Q91: Because SQL statements are table-oriented,whereas programs are