Which storage engine in MySQL provides foreign key support?

Answer: Option B

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.