Database Languages in SQL › Introduction to MySQL Databases › Question #15422
Single Choice Easy

QWhat is the purpose of the FOREIGN KEY constraint in MySQL?

ID: #15422 Introduction to MySQL Databases 110 views
Question Info
#15422Q ID
EasyDifficulty
Introduction to MySQL DatabasesTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A To enforce data integrity rules ✔ ✖
  • B To define the primary key of a table ✔ ✖
  • C To create an index for faster data retrieval ✔ ✖
  • D To specify default values for columns ✔ ✖
Correct Answer

Explanation

The FOREIGN KEY constraint in MySQL is used to establish a relationship between two tables based on a column or a combination of columns. It ensures that the values in the foreign key column(s) match the values in the referenced table's primary key column(s).

 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which MySQL command is used to modify the structure of a table? Which of the following is a widely used relational database management system? Which MySQL command is used to delete a database? Which MySQL data type is used to store a date and time value? What is the purpose of the GROUP BY clause in a MySQL query? Which MySQL statement is used to delete a table from a database? Which statement is used to create a new database in MySQL? What is the purpose of the WHERE clause in a MySQL query? Which MySQL statement is used to grant privileges to a user account? Which MySQL statement is used to insert data into a table?