Exam 1z0-908 topic 1 question 71 discussion

Actual exam question from Oracle's 1z0-908

Question #: 71
Topic #: 1

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

A. NDB
B. ARCHIVE
C. InnoDB
D. BLACKHOLE
E. MEMORY
F. MyISAM

Show Suggested Answer

Suggested Answer: BEF 🗳️

by Dhanushka at July 31, 2023, 3:15 p.m.

Comments

Submit Cancel

marklv

1 year, 10 months ago

bkackhole does not. tested. MEMORY doesn't rollback, so its MyISAM, ARCHIVE, and MEMORY

upvoted 2 times

...

Dhanushka

1 year, 11 months ago

Selected Answer: BEF

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.

upvoted 3 times

...

Dhanushka

1 year, 11 months ago

Selected Answer: AEF

Blackhole will show data

upvoted 1 times

marklv

12 months ago

blackhole is only meant to record data in the binlog. It wlll always succeed but never record data in the database,

upvoted 1 times

...