Home » MCQs » SQL MCQs » SQL Sub Queries, Views Clause MCQs

What is TRUE about UPDATE in SQL VIEW?

9. What is TRUE about UPDATE in SQL VIEW?

1. Views that depend on a single table can be updated.
2. An update of a view created from more than one table will not be allowed by SQL.
3. There should be no NULL values in the fields of view.
4. All of the above

Answer: D) All of the above

Explanation:

UPDATE in SQL VIEW states that-

1. Views that depend on a single table can be updated.
2. An update of a view created from more than one table will not be allowed by SQL.
3. There should be no NULL values in the fields of view.