首页  /  试题详情

单选题 试题 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=4 

slave_preserve_commit_order=0 

Which statement is true?

A、 Each slave thread is responsible for updating a specific database
B、 Cross-database constraints can cause database inconsistency.
C、 Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK. 
D、 Increasing slave_parallel_workers will improve high availability
E、 Setting slave_preserve_commit_order to ON will improve data consistency.
F、 Setting transaction_allow_batching to ON will improve data consistency.
查看答案
下载APP答题
由4l***zf提供 分享 举报 纠错
题库推荐
mysql ocp考试
2025-07-01
共248道
mysql ocp考试
2025-06-19
共248道
mysql ocp考试
2025-07-01
共248道
mysql ocp考试(1)
2025-07-16
共248道
mysql ocp考试
2025-07-22
共248道

相关试题

单选题 试题 126: Choose the best answer. 

Examine this command:shell> mysqldump --no-create-info --all-databases --result-file=dump.sql 

Which statement is true?

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.

单选题 试题 132: 

Choose the best answer.MySQL Enterprise Monitor Query Analyzer is configured to monitor an 

instance. Which statement is true?

A、The Query Response Time index (QRTi) is fixed to 100ms and cannot be customized.
B、Enabling the events_statements_history_long consumer allows tracking the longest running query
C、An agent must be installed locally on the instance to use the Query Analyzer.
D、The Query Analyzer can monitor an unlimited number of normalized statements
E、The slow query log must be enabled on the monitored server to collect information for the Query Analyzer

单选题 试题 129: 

What does the slave I/O thread do?

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

单选题 试题 128: Choose the best answer. 

Examine this command, which executes successfully:$ mysqlbackup --user=dba --password --port= 

3306 --with-timestamp --only-know-file-types --backup-dir=/export/backups backup 

Which statement is true?

A、Only tables stored in their own tablespaces are backed up
B、Only InnoDB data and log files are backed up
C、Only non-encrypted files are backed up.
D、Only files for MySQL or its built-in storage engines are backed up
E、The backup includes only data files and their metadata

单选题 试题 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”,.......“ST ATUS”: 

”ONLINE”,“version”;”8.0.18’Which statement explains the state of the instance 

deployed on host2?

A、It can rejoin the cluster by using the command cluster.addInstance ('<user>@host3:3377' ) .
B、It has been expelled from the cluster because of a transaction error.
C、It can be recovered from a donor instance on host3 by cloning using the command 

cluster.rejoinInstance ('<user>@host3:3377' ) .

D、It has been removed from the cluster by using the command STOP GROUP_REPLICATION;
E、It can rejoin the cluster by using the command dba. rebootClusterFromCompleteOutage() .

单选题 试题 130: 

Choose the best answer. Which statement is true about the my.ini file on a Windows platform 

while MySQL server is running?

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
C、Editing the file will immediately change the running server configuration
D、Using SET PERSIST will update the my.ini file

单选题 试题 131: 

Examine the full path name of the backup image from MySQL Enterprise Backup with the -- 

compress option:/backup/full/mybackup/myimage.img 

mysqlbackup.cnf contains this data: mysqlbackup backup-dir=/backup/full/myrestore backup

image=/backup/full/mybackup/myimage.img uncompress 

You must perform a database restore to a new machine. 

which command can provision the new database in datadir as /data/MEB?

A、mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB restore-and-apply-log
B、mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB image-to-dir-and-apply-log
C、mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB apply-log-and-copy-back
D、mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB copy-back-and-apply-log
E、mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB image-to-dir

单选题 试题 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?

A、mysql>  SHOW GLOBAL VARIABLES;
B、shell>  mysql --print-defaults
C、shell>  mysqladmin --debug
D、shell>  mysqld - -help --verbose