MySQLl5.7-ocp-888 最新中午题库解析

codedba

1022

135页

82次

2021-03-23

免费下载

更多 IT 认证课程请访问    美河学习在线  www.eimhe.com 
 
Question: 1 
A MySQL database uses all InnoDB tables and is configured as follows: 
#MySQL 数据库使用所有 InnoDB 表，配置如下： 
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? 
#您将使用 mysqldump 设置复制从机。您将需要从正在运行的生产服务器上获取一致的备份。
该进程应该对活动数据库连接的影响最小。为了实现这一点，您将把哪两个参数传递给
mysqldump？ 
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? 
#考虑 MySQL 服务器中的  key buffer。关于这个特性，哪两种说法是正确的？ 
A.  It caches index blocks for MyISAM tables only. 
#它只缓存 MyISAM 表的索引块。 
B.  It caches index blocks for all storage engine tables. 
#它缓存所有存储引擎表的索引块。 
C.  It is a global buffer. 
#它是一个全局缓冲区。 

更多 IT 认证课程请访问美河学习在线 www.eimhe.com

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

# D.按每个连接设置。

E. It caches index blocks for InnoDB tables only.

# E.它只缓存 InnoDB 表的索引块。

Answer: A,C

Question: 3

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

#您有一个 MySQL 复制设置，并且有意停止从机上的 SQL 线程。

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?

#在保持 I/O 线程运行的同时，可以停止从机上的 SQL 线程的两个原因是什么？

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

# D.防止模式更改在验证之前传播到从属服务器

E. to prevent any transaction experiencing a deadlock

Answer:BC

Question: 4

Which three statements correctly describe MySQL InnoDB Cluster?

of 135

免费下载

mysql

关注

评论