Why would a database designer choose to use a composite primary key instead of a single-column primary key?

easy📝 Conceptual Q1 of 15

SQL - Table Constraints

ATo uniquely identify records using a combination of multiple columns

BTo allow duplicate values in the primary key columns

CTo simplify queries by using only one column as the key

DTo avoid defining any unique constraints on the table

Step-by-Step Solution

Solution:

Step 1: Understand primary keys
A primary key uniquely identifies each record in a table.
Step 2: Composite keys
A composite primary key uses multiple columns together to ensure uniqueness.
Final Answer:
To uniquely identify records using a combination of multiple columns -> Option A
Quick Check:
Composite keys combine columns for uniqueness [OK]

Quick Trick: Composite keys combine columns for uniqueness [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes