[Solved] Which of the following best describes the role of a FOREIGN KEY constraint in a database? — Ans: It ensures data in one table matches data in another table. | SQL

SQL - Table Constraints

Which of the following best describes the role of a FOREIGN KEY constraint in a database?

AIt speeds up queries by indexing columns.

BIt automatically deletes all records in a table.

CIt ensures data in one table matches data in another table.

DIt encrypts data stored in the table.

Step-by-Step Solution

Solution:

Step 1: Define foreign key purpose
A foreign key links a column in one table to a primary key in another, ensuring data consistency.
Step 2: Eliminate unrelated options
Speeding queries, deleting records, and encrypting data are unrelated to foreign keys.
Final Answer:
It ensures data in one table matches data in another table. -> Option C
Quick Check:
Foreign key = data consistency between tables [OK]

Quick Trick: Foreign keys link tables by matching data values [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following best describes the role of a FOREIGN KEY constraint in a database?