Question: SQL views are always updateable when _ _ _ _ _ _ _ _ . 1 8 ) _ _ _ _ _ _ A

SQL views are always updateable when ________.18)______
A) the view is based on any number of tables, with or without
computed columns, and the INSTEAD OF trigger is defined for
the view
B) the view is based on a single table with no computed columns, and
all non-null columns are present in 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!