[Solved] Given the table products with a UNIQUE constraint on product_code, what happens when you run this SQL?INSERT INTO products (product_code, name) VALUES ('X123', 'Item A'); | SQL

SQL - Table Constraints

Given the table products with a UNIQUE constraint on product_code, what happens when you run this SQL?

INSERT INTO products (product_code, name) VALUES ('X123', 'Item A');
INSERT INTO products (product_code, name) VALUES ('X123', 'Item B');

AThe second insert fails with a UNIQUE constraint violation error

BThe second insert overwrites the first row

CBoth rows are inserted successfully

DThe database ignores the second insert silently

Step-by-Step Solution

Solution:

Step 1: Analyze UNIQUE constraint effect on the insert statements
The UNIQUE constraint on product_code means no two rows can have the same product_code value. The first insert adds 'X123' successfully. The second insert tries to add the same product_code 'X123', which violates the UNIQUE constraint, causing an error.
Final Answer:
The second insert fails with a UNIQUE constraint violation error -> Option A
Quick Check:
Duplicate insert on UNIQUE column = error [OK]

Quick Trick: Duplicate UNIQUE values cause insert errors [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table products with a UNIQUE constraint on product_code, what happens when you run this SQL?