网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题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” 相关考题
考题
单选题Identify a performance impact when using the Performance Schema.（）A
There is no impact on performanceB
The overhead depends on the settings of the Performance SchemaC
There is an overhead for querying the Performance Schema but not for having it enabledD
There 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?（）A
12; only top-level statements and stored procedure events are loggedB
111; top-level statements and all lower-level statements are loggedC
3; only the top-level statements are loggedD
102; 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
热门标签
最新试卷