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
您可能感兴趣的试卷
你可能感兴趣的试题
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
The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?()
A.A
B.B
C.C
D.D
The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE ‘validate_password%’;
When attempting to set your password, you get the following error: Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?()
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
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?()
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
Consider the following table:
Which method should used to add a new g201305 partition to the table?()
A.A
B.B
C.C
D.D
E.E
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
最新试题
Which two options describe how MySQL Server allocates memory?()
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?()
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?()
What is true regarding InnoDB locking?()
Which statement is true about the log-output variable?()
Which three tasks can be performed by using the performance Schema?()
You need to dump the data from the master server and import it into a new slave server.Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?()
Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?()
MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?()
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()