Multiple choice

Which of the following is not true about the limitations of view?

  1. If you use the DISTINCT clause to create a view, you cannot update or insert records within that view.

  2. If you do insert or update records through a join view, all records that are updated must belong to the same physical table.

  3. Virtual columns can be updated.

  4. You cannot use DELETE statements on multiple table views.

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

We cannot update a virtual column (a column that is the result of an expression or function).

Keep practicing — related questions