Match each database concept to its definition.
Drag a concept onto its matching description — or click a concept then click the description.
Unique identifier for each record in a table
Field that links to primary key in another table
Structure to speed up data retrieval
Virtual table based on a query result
Process to reduce data redundancy
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Primary Key: Uniquely identifies each record in a table.
Primary keys uniquely identify records, foreign keys link tables, indexes speed retrieval, and normalization reduces redundancy. Common confusions include swapping primary and foreign key definitions.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Primary Key: Uniquely identifies each record in a table.
Why this is correct
A primary key uniquely identifies each record in a table.
Foreign Key: A field that links to the primary key of another table.
Why this is correct
A foreign key is a field that references the primary key of another table.
Index: Speeds up data retrieval operations on a table.
Why this is correct
An index is used to speed up the retrieval of rows from a table.
Normalization: Process of organizing data to reduce redundancy.
Why this is correct
Normalization is a process that removes data redundancy and dependency.
Primary Key: A field that links to the primary key of another table.
Why it's wrong here
Incorrect — this describes a foreign key, not a primary key.
Foreign Key: Uniquely identifies each record in a table.
Why it's wrong here
Incorrect — this describes a primary key, not a foreign key.
Go deeper
About these practice questions
This DA0-002 question is part of Courseiva's 986-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.