Microsoft
98-364 · Question #187
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…
The correct answer is D. a primary key constraint violation. See the full explanation below for the reasoning.
Question
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?
Options
- Aa foreign key constraint violation
- Ba syntax error
- Ca new row in the Product table
- Da primary key constraint violation
- Ea new row in the Category table
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- D81% (25)
- E10% (3)
Community Discussion
No community discussion yet for this question.