Oracle 1Z0-908 Exam - Topic 6 Question 5 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 5
Topic #: 6

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

ANDB

BARCHIVE

CInnopB

DBLACKHOLE

EMEMORY

FMyISAM

Show Suggested Answer

Suggested Answer: A, D, F

by Kristel at May 09, 2022, 09:11 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Katheryn

5 months ago

I disagree, BLACKHOLE should return empty results.

upvoted 0 times

...

Carin

5 months ago

Surprised that BLACKHOLE is even an option!

upvoted 0 times

...

Muriel

5 months ago

ARCHIVE won't return anything, right?

upvoted 0 times

...

Linwood

5 months ago

I think NDB is also a good choice here.

upvoted 0 times

...

Glory

5 months ago

MyISAM and MEMORY will definitely return records.

upvoted 0 times

...

Olen

6 months ago

I practiced a similar question about storage engines, and I recall that MEMORY tables are volatile, so they might not return anything after a rollback.

upvoted 0 times

...

Rebecka

6 months ago

I think MyISAM might be one of the answers since it allows for rollback, but I need to double-check if it retains data after a rollback.

upvoted 0 times

...

Chi

6 months ago

I remember that TRUNCATE is a DDL operation, so it should reset the table, but I'm not sure how that interacts with the storage engines.

upvoted 0 times

...

Joseph

6 months ago

I’m leaning towards NDB and MyISAM, but I’m not confident about ARCHIVE. Does anyone remember if it can store data after a rollback?

upvoted 0 times

...

Alyce

6 months ago

This is a tricky one. I'm a bit confused on the EIGRP peering between the routers. I'll need to review that part of the material before I can confidently select an answer.

upvoted 0 times

...

Sabine

6 months ago

I'm pretty confident that the correct answer is to use the employee bill rate override at the project level. That seems like the most straightforward way to handle this situation.

upvoted 0 times

...

swotiz

3 years ago

The correct is A, E, F (I tested it on my machine)

upvoted 1 times

...