Question

When are SQL views updatable?

1) When the view is based on a single table with no computed columns, and all non-null columns are present in the view
2) When the view is based on multiple tables with computed columns, and all columns are present in the view
3) When the view is based on a single table with computed columns, and all non-null columns are present in the view
4) When the view is based on multiple tables with no computed columns, and all columns are present in the view

Answer 1

SQL views are updatable when based on a single table with no computed columns and all non-null columns are present in the view.

Step-by-step explanation:

SQL views are updatable in certain conditions. The answer is option 1) When the view is based on a single table with no computed columns, and all non-null columns are present in the view. In this case, any changes made to the view can be reflected in the underlying table.