mysql ocp考试(1)

Choose the best answerYou want to log only the changes made to the database objects and data 

on the MySQL system. 

Which log will do this by default?

Choose the best answer. 

Examine this partial output for InnoDB Cluster status:（见下图）Which statement explains the 

state of the instance deployed on host2?

（含图）

Choose the best answer. You use Row Based Replication and need to see \pseudo-SQL\ statements 

 for the replication event that is located in the log_file position NNNNN file. 

Which command should you use?

Choose the best answer. Which utility would you use to view the queries in the slow query 

log sorted by average query time?

Choose the best answer.Examine the command, which executes successfully: shell>mysqld --initialize 

Which statement is true?

Your MySQL environment has asynchronous position based-replication with one master and one slave.The 

slave instance had a disk I/O problem, so it was stopped. You determined that the slave relay log files were 

 corrupted and unusable, but no other files are damaged. You restart MySQL Server

How can replication be restored?

.Examine this configuration:You have a corporate private network, which uses its own Certificate 

Authority (CA) using an industry standard 2048-bit RSA key length. All MySQL Server and client 

certificates are signed using the central corporate CA. All clients are known, controlled,,and exist 

only on the private LAN. The private network uses its own private authoritative DNS. The private 

network also uses other nominal enterprise services. An end-to-end encrypted connection for a 

MySQL client to MySQL server has been established on this LAN. 

How does the MySQL Servers' self signed certificate compare to one that would be signed by a 

known public, third party trusted Certificate Authority?

You wish to store the username and password for a client connection to MySQL server in a file on a 

 local file system. Which is the best way to encrypt the file?

Examine these statements and output: 

mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ; 

mysql> SELECT USER() , CURRENT_USER() , @@proxy_user;（见下图） 

Which statement is true?

（含图）

You recently upgraded your MYSQL installation to MYSQL8.0 Examine this client error:Error 2059 

(HY000) :authentication plugin ‘caching_sha2_password’ cannot beLoaded:/usr/local/mysql/ 

libplugin/caching_sha2_password.so:cannot open shared object file:No such or directory 

Which option will allow this client to connect to MYSQL Server?

 Which condition is true about the use of the hash join algorithm?

You created a full backup and successfully tested the upgrade process on a test server. 

You then upgraded the production environment successfully. 

Soon after the upgrade, the application team reported a problem and asked you to roll back the upgrade.

Which statement is true?

（含图）

Why does the file contain no visible statement events?

The overall MySQL Server performance has degraded with the addition of more users performing the same tasks. 

What do you recommend?

M and InnoDB storage engines for your data. Examine your backup requirement:

·The MySQL system being backed up can never be unavailable or locked to the client applications. 

· The recovery from the backup must work on any system. 

· Only 1 hour of data can be lost on recovery of the backup

Which option fulfills all backup requirements?

（含图）

What is the reason for the error?

（含图）

You want to add one or more indexes that minimize the work done by the query. 

Which statement accomplishes this?