网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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?（）
A.Activating the MySQL Enterprise thread pool plugin
B.Relocating your data and log files to separate storage devices
C.Disconnecting idle localhost client sessions
D.Implementing storage engine data compression options
参考答案
更多 “ 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?（）A.Activating the MySQL Enterprise thread pool pluginB.Relocating your data and log files to separate storage devicesC.Disconnecting idle localhost client sessionsD.Implementing storage engine data compression options ” 相关考题
考题
修改MySQL用户root的密码的指令是?()
A.mysqladmin-urootpasswordtestB.mysql-urootpasswordtestC.mysql-uroot-ptestD.mysql-uroot-passwordtest
考题
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
考题
When backing up a replication slave, which three should also be backed up in addition to data?()
A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table
考题
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
考题
php连接上mysql之后,采用哪个函数配置循环可以得到指定表中的记录?()
A.mysql_fetch_rowB.mysql_select_dbC.mysql_queryD.mysql_connect
考题
连接mysql数据库服务器的函数是什么？A．mysqli_connect()B．mysqli_query()C．mysqli_error()D．mysqli_select_db()
热门标签
最新试卷