Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q19: The purpose of creating databases indexes is
Q20: Adding rows to a view is most
Q21: What does this SQL command accomplish? ALTER
Q22: An index makes certain types of retrieval
Q23: When renaming columns for a view, you
Q25: Which of the following commands deletes an
Q26: Which privilege can be granted to allow
Q27: When users create, alter, or drop tables
Q28: Which command will allow user Thompson to
Q29: What are the disadvantages of using an