SQL for Database Construction - Technical MCQs

Q1:

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

A a particular column in a particular underlying table.

B a particular column in a particular row.

C a particular row in a particular underlying table.

D None of the above is correct.

ANS:C - a particular row in a particular underlying table.

No answer description is available. Let's discuss.