What happens if Samantha, whose view of the database contains only a portion of the rows and columns of the base table, attempts to add a row to the table through her view?
A) Samantha's INSERT command will automatically be rejected.
B) Samantha could accidentally add a row with a duplicate primary key to the table.
C) If Samantha's INSERT command succeeds, the new row will contain several null values.
D) If all the columns in the base table accept nulls, Samantha's INSERT command will fail.

Question

Quizplus · Accepted Answer

When inserting a row through a view that only includes a portion of the base table's columns, any columns not included in the view will be set to null in the new row, assuming the table's constraints allow for null values in those columns.

What Happens If Samantha, Whose View of the Database Contains