SQL - Table Constraints
Which of the following is the correct way to name a primary key constraint on a table named
Employees?Which of the following is the correct way to name a primary key constraint on a table named Employees?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the common prefix for primary key constraints
Primary key constraints commonly start withPK_.Step 2: Combine prefix with table name
The convention is prefix + underscore + table name, soPK_Employeesis correct.Final Answer:
PK_Employees -> Option BQuick Check:
Primary key prefix = PK_ [OK]
Quick Trick: Use PK_ prefix plus table name for primary keys [OK]
Common Mistakes:
MISTAKES- Using full words like PrimaryKey_ instead of PK_
- Placing prefix after table name
- Mixing words in wrong order
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes