What is the result?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *