Deprecated -Subject Database Management System › Data Constraints and Integrity - MySQL › Question #15506
Single Choice Easy

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

ID: #15506 Data Constraints and Integrity - MySQL 129 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

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 another table?... Which type of data constraint in MySQL uniquely identifies each row in a table?... Which type of data constraint in MySQL allows the creation of an ordered sequence of numeric values for a column?... 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 provided during insertion?...