Oracle Exam 1Z0-908 Topic 3 Question 38 Discussion

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

Question #: 38
Topic #: 3

[All 1Z0-908 Questions]

Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

AMyISAM

BNDB

CMEMORY

DARCHIVE

EInnoDB

Show Suggested Answer

Suggested Answer: A, C

by Stephane at May 03, 2022, 04:44 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

swotiz

2 years ago

I'm sorry, but the correct answer is not MEMORY and MyISAM. Both of these storage engines do not provide a view of the data consistent with the storage system at any moment. The correct answer is InnoDB and NDB. These storage engines use mechanisms such as multi-versioning concurrency control (MVCC) to ensure that queries see a consistent view of the data, even if other transactions are modifying it at the same time. InnoDB is the default storage engine for MySQL, and NDB (also known as MySQL Cluster) is a storage engine designed for high availability and scalability. So, the correct options are: InnoDB NDB

upvoted 1 times

...