单项选择题X 纠错

A.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
B.STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
C.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
D.STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

参考答案:
查答案就用赞题库小程序 还有拍照搜题 语音搜题 快来试试吧
无需下载 立即使用

你可能喜欢

多项选择题

A.Setting — skip-networking when remote connections are not required
B.Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
C.Setting specific GRANT privilege to limit remote authentication
D.Setting – mysql_secure_configuration to enable paranoid mode
E.Using SSL when transporting data over remote networks

单项选择题

A.Start the server with the – innodb_recover_options option set to FORCE
B.Start the server with the – innodb_force_recovery option set to a non-zero value
C.Start the server as usual, and then execute the REPAIR TABLE command
D.Start the server as usual, and then execute the CHECK TABLE command

多项选择题

A.It rejects statements that try to insert out-of-range values
B.It rejects invalid dates
C.It limits the operations that the server can perform
D.It rejects queries that produce out-of-range values
E.It rejects dates with zero day or month values

单项选择题

A.The password is eight characters long, but needs to exceed validate_password_length to be valid
B.All of the MEDIUM password policy requirements have not been honored
C.The password matches a substring Hover as a dictionary word
D.The password does not match the validate_passoword_number_count requirement
E.There is no dictionary file defined, so password validation cannot work as expected

单项选择题

A.By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B.By enabling the Error Log because not using indexes is an error
C.By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D.By enabling the Error Log and using the – log-queries-not-using-indexes option

多项选择题

A.Use of soft links for database directories on the same physical disk
B.Use of delay_key_write=ON for batch index update
C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D.Placement of InnoDB log files and datadir on separate physical disks
E.Use of separate directories on the same physical disk for log files and data files

多项选择题

A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup

多项选择题

A.Shell> mysqladmin –u root –p shutdown
B.Shell> nmc mysql shutdown
C.Mysql> STOP PROCESS mysqld
D.Shell> /etc/init.d/mysql stop
E.Shell> service mysql safe_exit
F.Shell> pkill –u mysql mysqld_safe
G.Shell> net stop mysql

赞题库

赞题库-搜题找答案

(已有500万+用户使用)


  • 历年真题

  • 章节练习

  • 每日一练

  • 高频考题

  • 错题收藏

  • 在线模考

  • 提分密卷

  • 模拟试题

无需下载 立即使用

版权所有©考试资料网(ppkao.com)All Rights Reserved