Consider the table orders(order_id INT PRIMARY KEY, quantity INT NOT NULL CHECK (quantity > 0)). What happens if you insert (101, NULL)?

medium📝 query result Q5 of 15

SQL - Table Constraints

Consider the table orders(order_id INT PRIMARY KEY, quantity INT NOT NULL CHECK (quantity > 0)). What happens if you insert (101, NULL)?

AInsert fails because quantity cannot be NULL

BInsert succeeds with quantity set to 0

CInsert succeeds ignoring the CHECK constraint

DInsert fails due to PRIMARY KEY violation

Step-by-Step Solution

Solution:

Step 1: Review NOT NULL constraint on quantity
Quantity must have a value; NULL is not allowed.
Step 2: Analyze the insert with NULL quantity
Inserting NULL violates NOT NULL constraint, so insert fails.
Final Answer:
Insert fails because quantity cannot be NULL -> Option A
Quick Check:
NOT NULL prevents NULL inserts [OK]

Quick Trick: NOT NULL forbids empty values in columns [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes