SQL - Table Constraints
Consider the table products with column price DECIMAL(10,2) NOT NULL. What will be the result of this query?
INSERT INTO products (price) VALUES (NULL);
Consider the table products with column price DECIMAL(10,2) NOT NULL. What will be the result of this query?
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the NOT NULL constraint on price
The price column cannot accept NULL values.Step 2: Analyze the insert statement
Inserting NULL violates the NOT NULL constraint, causing the query to fail.Final Answer:
The query fails due to NOT NULL constraint violation -> Option BQuick Check:
NOT NULL rejects NULL inserts causing failure [OK]
Quick Trick: NOT NULL columns reject NULL inserts [OK]
Common Mistakes:
MISTAKES- Assuming NULL converts to zero
- Expecting default value without DEFAULT clause
- Ignoring constraint errors
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes