SQL - Database Design and Normalization
Which of the following is a key reason to use primary keys in database tables?
Which of the following is a key reason to use primary keys in database tables?
easy📝 Conceptual Q11 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the role of primary keys
Primary keys uniquely identify each row in a table, preventing duplicates.Step 2: Compare options with primary key purpose
Only To uniquely identify each record in the table describes uniqueness, which is the main purpose of primary keys.Final Answer:
To uniquely identify each record in the table -> Option DQuick Check:
Primary key = unique record ID [OK]
Quick Trick: Primary keys always ensure unique records [OK]
Common Mistakes:
- Thinking primary keys store large text
- Confusing primary keys with performance hardware
- Believing primary keys allow duplicates
Master "Database Design and Normalization" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes