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.)

Question

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.)

Accepted Answer

A. NDB D. BLACKHOLE F. MyISAM

Answer

B. ARCHIVE

Answer

C. InnopB

Answer

E. MEMORY

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion