Examveda
Examveda

Which storage engine in MySQL provides foreign key support?

A. TRANSACTION

B. InnoDB

C. MyISAM

D. MEMORY

Answer: Option B

Solution(By Examveda Team)

The InnoDB storage engine in MySQL provides foreign key support.
Foreign keys are constraints that enforce referential integrity between tables. InnoDB is the only storage engine in MySQL that supports foreign key constraints, allowing for the enforcement of relational integrity in the database.
Option A, TRANSACTION, is incorrect because TRANSACTION is not a storage engine in MySQL.
Option C, MyISAM, is incorrect because MyISAM does not support foreign key constraints.
Option D, MEMORY, is incorrect because the MEMORY storage engine does not support foreign key constraints.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous