Posted by: Pdfprep
Post Date: October 18, 2020
You have a table named Product that contains the following data.
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, ‘Table’, 4444)
What is the result?
A . a foreign key constraint violation
B . a syntax error
C . a new row in the Product table
D . a primary key constraint violation
E . a new row in the Category table
Answer: D
Leave a Reply