[Solved] Given the table creation:CREATE TABLE products ( id INT, price DECIMAL(5,2), CONSTRAINT chk_price CHECK (price >= 0) );What happens if you run:INSERT INTO products (id, price) VALUES (1, -10.00); | SQL

SQL - Table Constraints

Given the table creation:

CREATE TABLE products (
  id INT,
  price DECIMAL(5,2),
  CONSTRAINT chk_price CHECK (price >= 0)
);

What happens if you run:

INSERT INTO products (id, price) VALUES (1, -10.00);

AThe row is inserted successfully

BThe price is automatically set to 0

CThe insert fails due to CHECK constraint violation

DThe insert causes a syntax error

Step-by-Step Solution

Solution:

Step 1: Understand the CHECK constraint on price
The constraint requires price to be greater than or equal to 0.
Step 2: Analyze the insert statement
The insert tries to add price = -10.00, which violates the CHECK condition.
Final Answer:
The insert fails due to CHECK constraint violation -> Option C
Quick Check:
price < 0 violates CHECK = insert fails [OK]

Quick Trick: CHECK rejects rows violating the condition [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 creation: