Oracle MySQL 5.7 Database Administrator - 1Z0-888

You are remotely logged in to MySQL as the user "backup".
The account has temporarily been granted full privileges WITH GRANTto perform the actions required.
You want to change the password for the locally existing "backup" user.
Select the three commands which will perform the required action. (Choose three.)

• A. SET PASSWORD = `password';
• B. SET PASSWORD FOR `backup'@'localhost' = `password';
• C. ALTER USER `backup'@'localhost' IDENTIFIED BY `password';
• D. CREATE USER `backup'@'localhost' IDENTIFIED BY `password';
• E. ALTER USER USER() IDENTIFIED BY `password';
• F. ALTER USER `backup' IDENTIFIED BY `password';
• G. SET PASSWORD FOR `backup'@'localhost' = PASSWORD(`password')

In which order does MySQL process an incoming INSERT statement?

• A. It checks whether the user is authorized to perform the query, optimizes it, and then writes to the binary log.
• B. It writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.
• C. It optimizes the query, checks whether the user is authorized to perform it, and then writes to the binary log.
• D. It checks whether the user is authorized to perform the query, writes to the binary log, and then optimizes it.

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 difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"
• B. 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.
• C. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.
• D. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.
• E. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
  80, which is in use by the built-in web server.
• B. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• C. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
• D. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
• E. The mysql service has already been started on the same port.

Which two methods will provide the total number of partitions on a table? (Choose two.)

• A. Use the command: SHOW TABLE STATUS
• B. Use the command: SHOW CREATE TABLE
• C. Query the INFORMATION_SCHEMA.TABLES table for the partition_count
• D. Query the INFORMATION_SCHEMA.PARTITIONS table
• E. Query the performance_schema.objects_summary_global_by_type table