Examine these statements, which execute successfully:
TRUNCATE test;
BEGIN;
INSERT INTO test(id, name) VALUES(1, “Hello”);
ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
The ARCHIVE storage engine does not support transactions, so once data is inserted, it cannot be rolled back, leading to a nonempty recordset. The MEMORY storage engine also does not support transactional operations; thus, the inserted data remains even if a rollback is issued. Finally, MyISAM does not support transactions, meaning the inserted data would persist, resulting in a nonempty recordset.
B. ARCHIVE - This engine is for storing large amounts of data without indexes in a very small footprint. It does not support transactions, so the INSERT would not be rolled back.
Blackhole will show data
blackhole is only meant to record data in the binlog. It wlll always succeed but never record data in the database,
bkackhole does not. tested. MEMORY doesn't rollback, so its MyISAM, ARCHIVE, and MEMORY