MySQL OCP5.7考试题目大全.docx

MySQL 5.7 OCP 考试习题大全 Question: 1 A MySQL database uses all InnoDB tables and is configured as follows: shellcat/ etc/ f [mysqld] log-bin server-id=1 You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections. Which two arguments will you pass to mysqldump to achieve this? A.--skip-opt B.--lock-all-tables C.--create-apply-log D.--single-transaction E.--master-data Answer: DE Question: 2 Consider the key buffer in a MySQL server. Which two statements are true about this feature? A.It caches index blocks for MyISAM tables only. It caches index blocks for all storage engine tables. It is a global buffer. It is set on a per-connection basis. It caches index blocks for InnoDB tables only. Answer: A,C Question: 3 You have a MySQL replication setup and you intentionally stop the SQL thread on the slave. mysql SHOW SLAVE STATUS\ G ... Slave_IO_Running: Yes Slave_SQL_Running: No What are two reasons that you may stop the SQL thread on the slave while keeping the I/ O thread running? to allow the remaining events to be processed on the slave while not receiving new events from the master to allow a backup to be created under reduced load to allow for point-in-time recovery on the slave to prevent schema changes from propagating to the slave before they are validated to prevent any transaction experiencing a deadlock Answer: C，D Question: 4 Which three statements correctly describe MySQL InnoDB Cluster? The cluster can be operated in multimaster mode with conflict detection for DML statements. All MySQL client programs and connectors can be used for executing queries. It provides fully synchronous replication bentowdeeesn. the There is support for automatic failover when foanielsn.ode The data is automatically shared between the nodes. Each query will be executed in parallel across the nodes. Answer: ABD Question: 1 A MySQL da