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

Verified
Correct Answer:
Verified
Q20: SQL triggers are used for _.<br>A)validity checking<br>B)providing
Q28: The SQL keyword MODIFY is used to
Q29: Which SQL keyword is used to change
Q39: To set a column value to an
Q40: The SQL keyword UNIQUE is used to
Q47: Unless it is being used to copy
Q63: Based on the tables below,which of the
Q87: Because SQL stored procedures allow and encourage
Q92: A set of SQL statements stored in
Q98: Which SQL statement is used to retrieve