Oracle 為慶祝 MySQL 30 周年，截止到 2025.07.31 之前。所有人均可以免費考取原價245美元的MySQL OCP 認證。

從今天開始，將英文題庫免費公布出來，并進行解析，幫助大家在一個月之內輕松通過OCP認證。

本期公布試題121~130

試題121:

Examine this SQL statement:mysql> GRANT r_read@localhost To mark WITH ADMIN 
OPTION;Which two are true? (Choose two.) 
D)Mark can revoke the r_read@localhost role from another role. [正確] 
C)Mark can grant the r_read@localhost role to another user. [正確] 
A)Mark can grant the privileges assigned to the r_ read@ localhost role to another user. [錯誤] 
E)ADMIN OPTION allows Mark to drop the role. [錯誤] 
B)ADMIN OPTION causes the role to be activated by default. [錯誤] 
F)Mark must connect from localhost to activate the r_ read@localhost role. [錯誤]

解析

SQL語句分析：GRANT r_read@localhost TO mark WITH ADMIN OPTION
正確選項D) Mark可以撤銷另一個角色的r_read@localhost角色
C) Mark可以將r_read@localhost角色授予其他用戶
中文解析這個SQL語句授予用戶'mark'對角色'r_read@localhost'的管理權限(WITH ADMIN OPTION)，這意味著：WITH ADMIN OPTION的作用：允許mark用戶將這個角色(r_read@localhost)授予其他用戶(選項C正確)允許mark用戶撤銷其他用戶/角色的這個角色(選項D正確)但不會自動將角色本身的權限授予mark用戶錯誤選項分析：A) 錯誤 - WITH ADMIN OPTION只允許管理角色分配，不是直接授予角色包含的權限E) 錯誤 - ADMIN OPTION不提供刪除角色的權限B) 錯誤 - ADMIN OPTION與角色是否默認激活無關F) 錯誤 - 角色激活與連接來源無直接關系，這是角色使用問題而非分配問題

試題122:

C)Manual download of separate product packages is required before installing them through 
MySQL Installer. [正確] 
E)It performs product upgrades. [錯誤] 
A)It provides only GUI-driven, interactive installations. [錯誤] 
B)It installs most Oracle MySQL products. [正確] 
D)It provides a uniform installation wizard across multiple platforms. [錯誤]   

解析

B) It installs most Oracle MySQL products. [正確] 
(它能安裝大多數Oracle MySQL產品)C) Manual download of separate product packages is required before installing them through MySQL Installer.[正確] 
(通過MySQL Installer安裝前需要手動下載單獨的產品包)A) It provides only GUI-driven, interactive installations.
(錯誤 - 它不僅提供GUI驅動的交互式安裝，還支持靜默安裝模式)D) It provides a uniform installation wizard across multiple platforms.
(錯誤 - 它不提供跨平臺的統一安裝向導，僅支持Windows平臺)E) It performs product upgrades.
(錯誤 - 它的主要功能是安裝而非產品升級)

試題123:

Choose threeWhich three actions are effective in capacity planning? 
B)buying more RAM [錯誤] 
C)buying more disk [錯誤] 
G)monitoring OS resources for patterns [正確] 
F)upgrading to the latest application version [錯誤] 
A)adding circular replication nodes for increased DML capability [錯誤] 
E)basing expected growth on an average of the last 3 years [正確] 
D)buying more CPU [錯誤] 
H)consulting the application team about any future projects and use [正確] 

解析

容量規劃的有效措施分析正確選項 (Choose three)
G) monitoring OS resources for patterns
(監控操作系統資源使用模式)
E) basing expected growth on an average of the last 3 years
(基于過去3年的平均值預測增長)
H) consulting the application team about any future projects and use
(咨詢應用團隊關于未來項目和使用情況)錯誤選項分析
B) buying more RAM
(錯誤 - 單純購買更多內存是解決方案而非規劃行為)C) buying more disk
(錯誤 - 單純購買更多磁盤是解決方案而非規劃行為)F) upgrading to the latest application version
(錯誤 - 升級應用版本是實施行為而非規劃行為)A) adding circular replication nodes for increased DML capability
(錯誤 - 添加復制節點是架構擴展而非規劃行為)D) buying more CPU
(錯誤 - 單純購買更多CPU是解決方案而非規劃行為)

試題124:

Choose the best answer.Four nodes are configured to use circular replication. Examine these 
configuration parameters for each each node:slave_parallel_type=DATABASE ; 
slave_parallel_workers=4slave_preserve_commit_order=0 Which statement is true? 
B)Cross-database constraints can cause database inconsistency. [正確] 
E)Setting slave_preserve_commit_order to ON will improve data consistency. [錯誤] 
C)Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to 
LOGICAL_CLOCK. [錯誤] 
F)Setting transaction_allow_batching to ON will improve data consistency. [錯誤] 
D)Increasing slave_parallel_workers will improve high availability. [錯誤] 
A)Each slave thread is responsible for updating a specific database. [錯誤]

解析

B) Cross-database constraints can cause database inconsistency.
(跨數據庫約束可能導致數據庫不一致)錯誤選項解析A) Each slave thread is responsible for updating a specific database.
(錯誤 - 每個slave線程不專門負責特定數據庫，DATABASE并行類型是按數據庫并行化)C) Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
(錯誤 - DATABASE并行類型在循環復制中是可用的，只是有特定限制)D) Increasing slave_parallel_workers will improve high availability.
(錯誤 - 增加并行工作線程數不直接影響高可用性)E) Setting slave_preserve_commit_order to ON will improve data consistency.
(錯誤 - 在DATABASE并行類型下此設置不影響跨數據庫事務順序)F) Setting transaction_allow_batching to ON will improve data consistency.
(錯誤 - 事務批處理會降低一致性保證)

試題125:

Examine this partial output for InnoDB Cluster 
status:“topology”;“host1:3377”:”address”;”host1:3377”,“mode”:”R/W”,.......“STATUS”:”ONLINE”,“version”;”8.0.18’,“host1:3377”:”address”;”host2:3377”,“mode”:”R/O”,.......“STATUS”:”MISSING”,,“host1:3377”:”address”;”host3:3377”,“mode”:”R/O”,.......“STATUS”:”ONLINE”,“version”;”8.0.18’Which statement explains the state of the instance 
deployed on host2? 
C)It can be recovered from a donor instance on host3 by cloning using the command 
cluster.rejoinInstance ('<user>@host3:3377'). [正確] 
E)It can rejoin the cluster by using the command dba. rebootClusterFromCompleteOutage(). [錯誤] 
A)It can rejoin the cluster by using the command cluster.addInstance ('<user>@host3:3377'). [錯誤] 
D)It has been removed from the cluster by using the command STOP GROUP_REPLICATION;. . [錯誤] 
B)It has been expelled from the cluster because of a transaction error. [錯誤] 

解析

檢查InnoDB Cluster的部分狀態輸出："topology": {"host1:3377": {"address": "host1:3377","mode": "R/W","STATUS": "ONLINE","version": "8.0.18"},"host2:3377": {"address": "host2:3377","mode": "R/O","STATUS": "MISSING"},"host3:3377": {"address": "host3:3377","mode": "R/O","STATUS": "ONLINE","version": "8.0.18"}
}哪個選項解釋了部署在host2上的實例狀態？C) It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377').
(它可以通過使用cluster.rejoinInstance命令從host3上的捐贈者實例克隆恢復)解析：host2狀態為"MISSING"但未被驅逐(expelled)可以通過從在線的host3實例克隆數據重新加入集群cluster.rejoinInstance是正確命令錯誤選項
E) It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage().
(它可以通過使用dba.rebootClusterFromCompleteOutage()命令重新加入集群)錯誤原因：該命令用于整個集群完全中斷后的恢復不適用于單個節點恢復A) It can rejoin the cluster by using the command cluster.addInstance ('<user>@host3:3377').
(它可以通過使用cluster.addInstance命令重新加入集群)
錯誤原因：addInstance用于添加全新實例不適用于已配置但MISSING的實例恢復D) It has been removed from the cluster by using the command STOP GROUP_REPLICATION;.
(它已通過使用STOP GROUP_REPLICATION命令從集群中移除)
錯誤原因：主動停止復制會顯示為OFFLINE而非MISSING題目未提供人為操作的證據B) It has been expelled from the cluster because of a transaction error.
(它因事務錯誤被驅逐出集群)
錯誤原因：被驅逐的實例會顯示為"ERROR"或明確標記為expelled"MISSING"僅表示無法連接

試題126:

Choose the best answer.Examine this command:shell> mysqldump --no-create-info --all-databases --result-file=dump.sql Which statement is true? 
D)It will not write CREATE TABLE statements. [正確] 
A)It will not write CREATE TABLESPACE statements. [錯誤] 
B)It will not write CREATE LOGFILE GROUP statements. [錯誤] 
C)It will not write CREATE DATABASE statements. [錯誤] 

解析

D) It will not write CREATE TABLE statements.
(該命令不會寫入CREATE TABLE語句)A) 錯誤 - TABLESPACE創建語句不受此參數影響B) 錯誤 - LOGFILE GROUP創建語句不受此參數影響C) 錯誤 - CREATE DATABASE語句不受此參數影響(除非使用--no-create-db)

試題127:

MySQL programs look for option files in standard locations.Which method will show the option files 
and the order in which they are read? 
C)shell> mysqladmin --debug [錯誤] 
A)mysql> SHOW GLOBAL VARIABLES; [錯誤] 
B)shell> mysql --print-defaults [錯誤] 
D)shell> mysqld - -help --verbose [正確] 

解析

正確選項D：mysqld --help --verbose命令會顯示：MySQL服務器啟動時讀取的選項文件列表這些文件的讀取順序所有可用配置參數及其默認值這是官方推薦的查看選項文件順序的標準方法MySQL程序按以下標準順序讀取選項文件：/etc/my.cnf/etc/mysql/my.cnfSYSCONFDIR/my.cnf$MYSQL_HOME/my.cnf~/.my.cnf (用戶特定)~/.mylogin.cnf (加密的登錄路徑文件)--help --verbose是最全面查看MySQL配置信息的標準方式開啟新對話

試題128:

Choose the best answer.Examine this command, which executes successfully:$ mysqlbackup -
user=dba --password --port=3306 --with-timestamp --only-known-file-types--backup
dir=/export/backups backup Which statement is true? C)Only non-encrypted files are backed up. [錯誤] 
E)The backup includes only data files and their metadata. [錯誤] 
D)Only files for MySQL or its built-in storage engines are backed up. [正確] 
A)Only tables stored in their own tablespaces are backed up. [錯誤] 
B)Only InnoDB data and log files are backed up. [錯誤] 

解析

關鍵參數：--only-known-file-types：僅備份MySQL識別的文件類型--with-timestamp：在備份目錄中添加時間戳--backup-dir：指定備份目錄正確選項D：--only-known-file-types參數確保只備份：MySQL系統文件內置存儲引擎(如InnoDB、MyISAM等)的文件不包括未知或第三方存儲引擎的文件錯誤選項分析：A) 錯誤 - 不限于單獨表空間存儲的表B) 錯誤 - 不只InnoDB文件，還包括其他引擎文件C) 錯誤 - 參數不影響加密文件的備份E) 錯誤 - 還包括日志文件等其他MySQL文件

試題129:

What does the slave I/O thread do? 
B)connects to the master and requests it to send updates recorded in its binary logs [正確] 
C)acquires a lock on the binary log for reading each event to be sent to the slave [錯誤] 
D)reads the relay log and executes the events contained in them [錯誤] 
A)monitors and schedules I/O calls to the subsystem for the relay logs [錯誤]

解析

B) connects to the master and requests it to send updates recorded in its binary logs
(連接到主庫并請求發送記錄在其二進制日志中的更新)Slave I/O 線程功能詳解主要職責：建立與主庫的連接請求主庫發送二進制日志(binlog)事件將接收到的binlog事件寫入從庫的relay log(中繼日志)保持與主庫的長連接，持續獲取更新A) monitors and schedules I/O calls to the subsystem for the relay logs
(監控和調度對中繼日志子系統的I/O調用)錯誤：這是操作系統層面的I/O調度，不是I/O線程的工作C) acquires a lock on the binary log for reading each event to be sent to the slave
(獲取二進制日志鎖以讀取要發送給從庫的每個事件)錯誤：這是主庫binlog dump線程的行為，不是從庫I/O線程的D) reads the relay log and executes the events contained in them
(讀取中繼日志并執行其中的事件)錯誤：這是從庫SQL線程的職責

試題130:

Choose the best answer.Which statement is true about the my.ini file on a Windows platform while 
MySQL server is running? 
C)Editing the file will immediately change the running server configuration. [錯誤] 
D)Using SET PERSIST will update the my.ini file. [錯誤] 
A)MySQL server does not use the my.ini option file for server configuration options. [錯誤] 
B)The option file is read by the MySQL server service only at start up. [正確] 

解析

my.ini文件在Windows平臺的特點正確選項B分析：MySQL服務只在啟動時讀取my.ini配置文件運行時修改不會自動生效需要重啟MySQL服務才能使配置變更生效A) MySQL server does not use the my.ini option file for server configuration options.
(MySQL服務器不使用my.ini選項文件進行服務器配置)錯誤：my.ini是Windows平臺MySQL的主要配置文件C) Editing the file will immediately change the running server configuration.
(編輯文件會立即改變運行中的服務器配置)錯誤：必須重啟服務才能使配置變更生效D) Using SET PERSIST will update the my.ini file.
(使用SET PERSIST會更新my.ini文件)錯誤：SET PERSIST會更新數據目錄下的mysqld-auto.cnf文件，而非my.ini