Oracle Exam 1Z0-888 Topic 8 Question 36 Discussion

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

Question #: 36
Topic #: 8

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

AYes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

BYes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

CNo. The UNDO tablespaces must remain on the same file system as the system tablespaces.

DNo. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

Show Suggested Answer

Suggested Answer: C

by Chauncey at May 09, 2022, 07:36 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!