SQL Views Are Always Updatable When ________

question 26

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

---

Definitions:

Hot Spot

An area of volcanic activity believed to be fueled by a section of the mantle beneath it that is significantly hotter than the mantle surrounding it.

Bonneville Salt Flats

A vast salt flat located in Utah, USA, known for its flat, expansive landscapes and as a site for land speed record attempts.

Terrane

A fragment of crustal material formed on, or broken off from, one tectonic plate and accreted or sutured to crust lying on another plate.

Subduction Zone

A region where subduction takes place, characterized by deep ocean trenches and volcanic activity.