A view is updatable when it is derived from joining two base tables on the ____ of each table.
A)row-column
B)foreign key
C)primary key
D)index

Question

A view is updatable when it is derived from joining two base tables on the ____ of each table.​
A)row-column
B)​foreign key
C)primary key
D)​index

Quizplus · Accepted Answer

A view can be updatable if it is derived from joining two base tables on the primary key of each table. This ensures that each row in the view can be uniquely mapped back to a row in the base table, allowing for updates to be made. Joining on a foreign key may not always result in a unique mapping, and joining on an index or row-column would not guarantee the necessary uniqueness.

A View Is Updatable When It Is Derived from Joining