A.When uptime is criticalB.When data must be refactored……

单项选择题You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ etc init.d mysql stop Shell＞ etc init.d mysql start – skip-grant tables Which additional argument makes this operation safer?（）

A.–skip-networking, to prohibit access from remote locations
B.–reset-grant-tables, to start the server with only the mysql database accessible
C.–read-only,to set all data to read-only except for super users
D.–old-passwords, to start Mysql to use the old password format while running without the grant tables

单项选择题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be rolled forward to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）

A.Gtid_mode must be set to AUTO during point in time recoveries
B.Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs
C.The server keeps track of which GTIDs have already been executed and skips those
D.Enforce_gtid_consistency is set to ON

单项选择题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be rolled forward to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）

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

多项选择题What are three methods to reduce Mysql server exposure to remote connections?（）

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

单项选择题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）

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