MySQL 8.0 Database Administrator — Question 36

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

Answer options

• A. MyISAM
• B. NDB
• C. MEMORY
• D. ARCHIVE
• E. InnoDB

Correct answer: A, C

Explanation

MyISAM and MEMORY are the only storage engines that provide a consistent view of the data at a specific moment. InnoDB and NDB offer different transactional capabilities, while ARCHIVE is designed for high compression and does not support updates, making them unsuitable for this requirement.