mysql ocp考试(1)

Choose the best answer.You have configured GTID-based asynchronous replication with one master 

and one slave. A user accidentally updated some data on the slave.To fix this, you stopped 

replication and successfully reverted the accidental changes. Examine the current GTID information: 

（见下图）You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of 

failover. Which set of actions would allow the slave to continue replicating without erroneous 

transactions?

（含图）

Your my.cnf file contains these settings: 

[mysqld] 

log_output=FILE slow_query_log 

long_query_time=2.01 

log_queries_not_using_indexes 

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 

seconds to run or did not use indexes. 

Which contains all the settings that you need to add to or modify the slow log configuration?

Choose the best answer. What does the binlog dump thread do?

（含图）

You wish to protect your MySQL database against SQL injection attacks. 

Which method would fail to do this?

 How can mysql_multi be configured to allow MySQL instances to use the same port number?

 You plan to upgrade your MySQL 5.7 instance to version 8. You have installed the 8 build of MySQL 

Shell.Examine this command executed from the operating system shell prompt: 

mysqlsh --uri root@localhost:3306 -- util check-for-server-upgrade 

Which statement is true?

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance 

database.Company policy is to create a backup every day.The main tables being updated are 

prefixed with transactions-.These tables are archived into tables that are prefixed with archives

each month. mysqlbackup --optimistic-busy-tables=\^finance\\. transactions-.*\ backup 

Which optimization process best describes what happens with the redo logs?

You must replay the binary logs on your MySQL server. 

Which command do you use?

Choose the best answer.Examine this statement, which executes successfully:（见下图）You want to 

improve the performance of this query:SELECT Name FROM world.city WHERE Population BETWEEN 

 1000000 AND 2000000; 

 Which change enables the query to succeed while accessing fewer rows?

（含图）

Examine this parameter setting:audit_log=FORCE_LOG_PERMANENT 

What effect does this have on auditing?

题干见下图:

（含图）

An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses: 

host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage () 

Reconfiguring the default cluster from complete outage. . . 

The instance ' host1:3377' was part of the cluster configuration. Would you like to rejoin it to 

the cluster? y/N :y 

The instance ' host2:3377' was part of the cluster configuration.Would you like to rejoin it to 

Dba.rebootClusterFromCompleteOutage:The active session instance isn't the most updated in 

comparison with the ONLINE instances of the Cluster's metadata. 

Please use the most up to date instance:' host1:3377'. (RuntimeError) 

Which statement is true?

Examine the command, which execute successfully:shell> mysqld  --initialize-insecure 

Which statement is true?

You are upgrading a MySQL instance to the latest 8.0 version. Examine this output:.（见下图）

（含图）

You plan to add this parameter to the configuration:innodb_directories= ' /innodb_extras ' 

Which statement is true?

You plan to take daily full backups, which include the ndbinfo and sys 

(internal) databases. Which command will back up the databases in parallel?

The languages table uses MyISAM and the countries table uses the InnoDB storage engine.Both 

tables are empty.Examine these statements:BEGIN;INSERT INTO languages(lang) VALUES 

(“Italian”) ;INSERT INTO countries(country) VALUES(“Italy”) ;ROLLBACK; 

What is the content of both tables after executing these statements?

What does the slave I/0 thread do?

 Choose the best answer. Examine these commands and results: 

SHOW GRANTS FOR jane; 

GRANT USAGE ON *.* TO ‘’（见下图） 

Jane must create a temporary table named TOTALSALES in the SALES database.Which statement 

will provide Jane with the required privileges based on the principle of least privilege?

（含图）

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?