MySQL OCP 5.7 1Z0-888.pdf - 墨天轮文档

MySQL OCP 5.7 1Z0-888.pdf

乔尼Zzz

510

98页

10次

2022-02-18

25墨值下载

MySQL 5.7 OCP 1Z0-888

（考试模拟练习题）

Question: 1

A MySQL database uses all InnoDB tables and is configured as follows:

shell>cat/ etc/ my.cnf

[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.

B. It caches index blocks for all storage engine tables.

C. It is a global buffer.

D. It is set on a per-connection basis.

E. 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?

A. to allow the remaining events to be processed on the slave while not receiving new events

from the master

B. to allow a backup to be created under reduced load

C. to allow for point-in-time recovery on the slave

D. to prevent schema changes from propagating to the slave before they are validated

E. to prevent any transaction experiencing a deadlock

Answer: D – (BC中选择一个，我倾向于B,然而C也讲得通。)

Question: 4

Which three statements correctly describe MySQL InnoDB Cluster?

A. The cluster can be operated in multimaster mode with conflict detection for DML statements.

B. All MySQL client programs and connectors can be used for executing queries.

C. It provides fully synchronous replication between the nodes.

D. There is support for automatic failover when one node fails.

of 98

25墨值下载

相关文档

评论