[Solved] Why does this statement cause an error?CREATE TABLE employees (id INT NOT NULL, name VARCHAR(50) NOT NULL, age INT NOT NULL DEFAULT NULL); | SQL

SQL - Table Constraints

Why does this statement cause an error?

CREATE TABLE employees (id INT NOT NULL, name VARCHAR(50) NOT NULL, age INT NOT NULL DEFAULT NULL);

AYou cannot set DEFAULT NULL on a NOT NULL column

BThe data type INT is invalid

CThe table name is reserved

DNOT NULL cannot be combined with VARCHAR

Step-by-Step Solution

Solution:

Step 1: Understand NOT NULL and DEFAULT NULL conflict
A NOT NULL column cannot have DEFAULT NULL because it contradicts the constraint.
Step 2: Analyze the statement
The age column is NOT NULL but has DEFAULT NULL, causing an error.
Final Answer:
You cannot set DEFAULT NULL on a NOT NULL column -> Option A
Quick Check:
NOT NULL columns cannot have DEFAULT NULL [OK]

Quick Trick: NOT NULL columns need non-NULL default or none [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Why does this statement cause an error?