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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion