MYSQL OCP试题

6

Choose the best answer.

You are having performance issues with MySQL instances .

您的 MySQL 实例 存在性能问题。

Those servers are monitored with MySQL Enterprise Monitor .

这些服务器用 MySQL 企业监控器 进行监控。

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

使用 查询分析器 ，您从哪里开始查找问题查询？

A) Sort the "Exec" column and check for SQL queries with low Query Response Time index

(QRTi) values.

对 “Exec” 列进行排序，并检查 查询响应时间 索引( QRTi ) 值 较低 的 SQL 查询。

B) Look for queries with low total latency times in the Latency section in the times series graph.

C) Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

D) Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

Answser ： A

https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-features-qrti.html

---

7

Choose the best answer.

You want to log only the changes made to the database objects and data on the MySQL system.

您只需要记录在 MySQL 系统上对数据库对象和数据所做的更改。

Which log will do this by default?

默认情况下，哪个日志将这样做？

A) slow query log

B) binary log 二进制文件

C) error log

D) general query log

E) audit log

Answser ： B

---

8

Choose two.

Identify two ways to significantly improve data security.

确定两种可显著提 高数据安全性 的方法。

A) Configure mysqld to run as the system admin account, such as root.

B) Use a private network behind a firewall.

behind 在...之后

在防火墙后面使用专用网络

C) Configure mysqld to use only networked disks.

D) Configure MySQL to have only one administrative account.

E) Configure mysqld to use only local disks or attached disks and to have its own account in the host system .

将 mysqld 配置为 只使用本地磁盘 或 附加磁盘 ，并在 主机系统 中 拥有自己的帐户 。

Answer:B E

分析：网络隔离 最好 ， D 的问题是 administrator 这个权限太大了，应该有多个

administrative account ，每个只有部分权限。

---

9

Choose two.

Which two statements are true about MySQL Enterprise Backup ?

关于 MySQL 企业备份 ，哪两个语句是正确的

A) It creates logical backups.

B) It supports backing up only table structures.

C) It can perform hot or warm backups.

热备份

D) It supports backup of a remote MySQL system.

E) It supports restoring to a remote MySQL system.

F) It supports the creation of incremental backups .

创建增量备份

Answer:C F

---

10

Choose the best answer.

Examine these commands, which execute successfully on the ic1 host:

检查一下在 ic1 主机上成功执行的这些命令：

mysqlsh> dba.createCluster( 'cluster1' , {memberWeight:35}) mysqlsh>

var mycluster = dba.getCluster ()

mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25})

mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50}) Now

examine this configuration setting, which is the same on all nodes:

group_replication_consistency =BEFORE_ON_PRIMARY_FAILOVER

Which statement is true if primary node ic1 fails?

如果主节点 ic1 失败，则哪个语句为真？

A) Node ic2 becomes the new primary and existing transactions are considered stale and rolled

back.

B) Node ic3 becomes the new primary and existing transactions are considered stale and rolled

back.

C) Node ic3 becomes the new primary and is ignored until any backlog of transactions is

completed.

节点 ic3 成为新的主节点，在任何事务积压完成之前被忽略。

D) Only two nodes remain so the election process is uncertain and must be done manually.

E) Node ic2 becomes the new primary and is ignored until any backlog of transactions is

completed.

Answer:C

---

个人总结练习，不断成长进步ヾ(◍°∇°◍)ﾉﾞ