[Solved] What is the main purpose of a CHECK constraint in SQL? — Ans: To enforce rules on column values to prevent invalid data | SQL

SQL - Table Constraints

What is the main purpose of a CHECK constraint in SQL?

ATo automatically generate unique IDs

BTo create a backup of the table data

CTo speed up query performance

DTo enforce rules on column values to prevent invalid data

Step-by-Step Solution

Solution:

Step 1: Understand what a CHECK constraint does
A CHECK constraint sets a rule that data must follow when inserted or updated in a table.
Step 2: Identify the purpose from the options
Only To enforce rules on column values to prevent invalid data describes enforcing rules on data to prevent invalid entries.
Final Answer:
To enforce rules on column values to prevent invalid data -> Option D
Quick Check:
CHECK constraint = enforce data rules [OK]

Quick Trick: CHECK constraints prevent bad data from entering tables [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is the main purpose of a CHECK constraint in SQL?