MySQL → Relational database concepts → MCQ Details
MCQ Practice Single Best Answer Topic: Relational database concepts

Q What is a foreign key in a relational database?

Question ID
#15428
Subchapter
Relational database concepts
Action
Choose one option below

Choose Your Answer

Click an option to check whether your answer is correct.

  • A A key used for sorting data in a table ✔ ✖
  • B A key used for joining two tables ✔ ✖
  • C A key that uniquely identifies a row in a table ✔ ✖
  • D A key that represents a relationship between tables ✔ ✖
Correct Answer: D

Explanation

A foreign key is a column or a set of columns in a table that refers to the primary key of another table. It establishes a relationship between two tables by enforcing referential integrity and allowing data to be shared and connected between them.

Related Topics

Explore more questions from similar topics.

Aggregation functions - MySQL Data Constraints and Integrity - MySQL Data definition language - MySQL Data manipulation language - MySQL Introduction to MySQL Databases Relational database concepts SQL and MySQL Stored functions and triggers - MySQL Transactions and ACID properties - MySQL

Share This Question

Share this MCQ with your friends or study group.