mysql ocp考试

Binary log events for the 'mydb1' schema must be copied to a different schema name 

'mydb2' . Which command will do this?

Examine this snippet片段 from the binary log file named binlog.000036: 

# at 5000324 

#191120 14155116 server id 1 end_log_pos 500453 crc32 0x98159515 Query thread_id=9 exec_time=2 

error_code=0xid=1106 

SET TIMESTAMP=1574222116/*!*/; 

DROP TABLE ‘rental’/* generated by server*/ 

/*!*/; 

The rental table was accidentally dropped, and you must recover the table.You have restored the last 

backup, which corresponds to the start of the binlog.000036 binary log. 

Which command will complete the recovery?

You recently upgraded your MySQL installation to MySQL 8.0. Examine this client error: 

ERROR 2059 (HY000) :Authentication plugin 'caching_sha2_password' cannot be loaded:/usr/local/ 

mysql/lib/plugin/caching_sha2_password.so:cannot open shared object file:No such file or directory 

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

Choose the best answer.Examine this SQL statement:UPDATE world.citySET Population = Population 

* 1.1WHERE CountryCode IN (SELECT Code FROM world.country WHERE Continent = ' Asia ' ) 

Which set of privileges will allow Tom to execute this SQL statement?

 Which command enables rule-based MySQL Auditing capabilities?

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise 

Monitor.Using Query Analyzer, where do you begin to look for problem queries?

（含图）

Choose the best answer.Examine this output:（见下图） 

Which change should optimize the number of buffer pool instances for this workload?

（含图）

Choose the best answer. You encountered an insufficient privilege error in the middle of a long 

transaction. The database administrator is informed and immediately grants the required 

privilege:GRANT UPDATE ON world.city TO 'user1' ; How can you proceed with your transaction 

with the least interruption?

There has been an accidental deletion of data in one of your MySQL databases. You determine that all 

 entries in the binary log file after position 1797 must be replayed. Examine this partial command: 

mysqlbinlog binlog.000008 --start-position=1798 

Which operation will complete the command?

The mysqld instance has the connection control plugin enabled with these settings: 

connection_control_min_connection_delay=1000 

connection_control_max_connection_delay=2000 

The minimum and maximum delays need to be increased to 3000 and 5000, respectively. 

A command is executed: mysql>SET GLOBAL connection_control_min_connection_delay=3000; 

What is the result?

number?

MySQL is installed on a Linux server with this configuration: 

[mysqld] 

user=mysql 

datadir=/data/mysql 

Which method sets the default authentication to SHA-256 hashing for authenticating user account 

passwords?

GLOBAL STATUS 

1:Com_create_table=500005 

Com_drop_table=500003 

Com_flush=23 

Create_tmp_disk_tables=400000 

Create_tmp_tables=1200000 

Max_used_connections=92 

Open_files=5000 

Opened_files=5000 

Open_table_definitions=3000 

Open_tables=1024 

Opened_table_definitions=2369 

Opened_tables=3500000 

Threads_connected=62 

Threads_running=58 

Uptime=100000GLOBAL STATUS 

2:Com_create_table=500505 

Com_drop_table=500498 

Com_flush=31 

Create_tmp_disk_tables=40040 

0Create_tmp_tables=1201200 

Max_used_connections=92 

Open_files=5000 

Opened_files=7505 

Open_table_definitions=3000 

Open_tables=1024 

Opened_table_definitions=2873 

Opened_tables=3503500 

Threads_connected=67 

Threads_running=64 

Uptime=100000 

Your MySQL system normally supports 50-75 concurrent connections. 

Which configuration change will improve performance?

A colleague complains about slow response time on your website. Examine this query and output: 

（见下图） What is the most likely cause for the high number of lock waits?

（含图）

Choose the best answer.（题干见图片） What is the reason for SSL not being used

（含图）

 You have configured a working MySQL InnoDB Cluster in single-primary mode. What happens 

when the primary instance goes down due to a network problem?

You have configured MySQL Enterprise Transparent Data Encryption (TDE) . What command would 

you use to encrypt a table?

Company database. There is a datadir copy from two days ago in the dbbackup directory. 

Which set of steps would restore only the missing table?

mysql> SHOW FULL PROCESSLIST;（下图过） 

Examine this query: 

SELECT SUM(m.CURRENT_NUMBER_OF_BYTES_USED) AS TOTAL FROM performance_schema.memory_ 

summary_by_thread_by_event_name m INNER JOIN performance_schema.threads t ON m.THREAD_ID = t. 

THREAD_ID WHERE t.PROCESSLIST_ID = 10;

What information does this query provide?

（含图）