MySQL › Data Constraints and Integrity - MySQL › Question #15506
MCQ Single Best Answer Easy

QWhich type of data constraint in MySQL ensures referential integrity between two tables?

ID: #15506 Data Constraints and Integrity - MySQL 100 views
Question Info
#15506Q ID
EasyDifficulty
Data Constraints and Integrity - MySQLTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

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

  • A PRIMARY KEY ✔ ✖
  • B UNIQUE ✔ ✖
  • C FOREIGN KEY ✔ ✖
  • D INDEX ✔ ✖
Correct Answer: Option C

Explanation

The FOREIGN KEY constraint in MySQL ensures referential integrity between two tables. It establishes a relationship between a column in one table and the primary key in another table.

 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 type of data constraint in MySQL ensures that a column must have a value? Which type of data constraint in MySQL ensures that a column's value references a valid primary key value in a Which type of data constraint in MySQL allows the creation of an ordered sequence of numeric values for a colu Which type of data constraint in MySQL uniquely identifies each row in a table? Which type of data constraint in MySQL ensures that a column can have a NULL value or a unique non-NULL value? Which type of data constraint in MySQL allows you to define custom data validation rules? Which type of data constraint in MySQL ensures that each value in a column must be unique? Which type of data constraint in MySQL automatically assigns a predefined value to a column if no value is pro