Oracle 1Z0-888 Actual Tests : MySQL 5.7 Database Administrator

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

• A. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.
• B. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.
• C. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.
• D. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"
• E. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

Which two options describe how MySQL Server allocates memory?

• A. Thread memory is pre-allocated up to thread_cache_size for performance.
• B. Each thread allocates memory from a global pool.
• C. Global memory resources are allocated at server startup.
• D. Each connection may have its own per-thread memory allocations.

You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.
Which three statements are true? (Choose three.)

• A. A connection must be instrumented to be included in the list of processes.
• B. The performance impact is less than SHOW FULL PROCESSLIST.
• C. The PROCESS privilege is required.
• D. The sys.session view provides the process list with additional information.
• E. The events_statements_current consumer must be enabled.
• F. The threads table contains all the required columns.

A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state. You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur?

• A. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• B. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• C. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql
• D. The applications have the SUPER privilege, which allows them to update rows.
• E. The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

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?

• A. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.
• B. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
• C. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.
• D. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.