多选题Which two events will cause a slave server to create a new relay log file?（）AExecution of the FLUSH LOGS statementBStarting of the SQL threadCReaching the slave_pendign _jobs_size_max limitDExecution of FULSH TABLES WITH READ LOCKEStarting of the I/O thread
多选题
Which two events will cause a slave server to create a new relay log file?（）
A
Execution of the FLUSH LOGS statement
B
Starting of the SQL thread
C
Reaching the slave_pendign _jobs_size_max limit
D
Execution of FULSH TABLES WITH READ LOCK
E
Starting of the I/O thread
参考解析
解析：
暂无解析
相关考题：
单选题Identify a performance impact when using the Performance Schema.（）AThere is no impact on performanceBThe overhead depends on the settings of the Performance SchemaCThere is an overhead for querying the Performance Schema but not for having it enabledDThere is a constant overhead regardless of settings and workload
多选题Which two statements are true about InnoDB auto-increment locking?（）AThe auto-increment lock can be a table-level lockBInnoDB never uses table-level locksCSome settings for innodb_autoinc_lock_mode can help reduce lockingDInnoDB always protects auto-increment updates with a table-level lock
多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending timeEFinding the size of each table
单选题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 validB All of the MEDIUM password policy requirements have not been honoredC The password matches a substring Hover as a dictionary wordD The password does not match the validate_passoword_number_count requirementE There is no dictionary file defined, so password validation cannot work as expected
单选题Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A12; only top-level statements and stored procedure events are loggedB111; top-level statements and all lower-level statements are loggedC3; only the top-level statements are loggedD102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
单选题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 AB BC CD D
多选题Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell＞ mysql –u root –p sakila sakila2013.sqlCShell＞ mysql import –u root –p sakila sakila2013.sqlDShell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell＞ mysql –u root –p –silent ＜ sakila2013.sql