单选题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?（）AMySQL requires correct file ownership while remaining secureBMySQL needs to be run as the root user, b

第1题：

第2题：

第3题：

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?（）

• A、Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';
• B、Shell＞ mysql –u root –p sakila sakila2013.sql
• C、Shell＞ mysql import –u root –p sakila sakila2013.sql
• D、Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'
• E、Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql

第4题：

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: /＞ mysqld – install Mysql56 – defaults – file = C :/my –opts.cnf What is the expected outcome?（）

• A、Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration file
• B、An error message is issued because – install is not a valid option for mysqld
• C、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
• D、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file

第5题：

You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）

• A、All system users have access to the MySQL server via—login path local
• B、login-path can be used only for MySQL servers running on a local machine
• C、login-path allows you to provide login credentials without passing clear text passwords on the command line
• D、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later

第6题：

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?（）

• A、The RPM installation script sets a default password of password for new installations
• B、The local root user must log in with a blank password initially: mysql –u root –p
• C、New security measures mean that the mysql_secure_installation script must be run first on all new installations
• D、The mysql_install_bd post-installation script used – random-password

第7题：

修改MySQL用户root的密码的指令是（）。

• A、mysqladmin -u root password test
• B、mysql -u root password test
• C、mysql -u root -p test
• D、mysql -u root -password test

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）

• A、Mysqld uses internal configuration versioning and reverts to the previous configuration
• B、When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
• C、The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
• D、Mysqld prints to the error log about an unknown variable, and then exits

第16题：

A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）

• A、It deletes all binary log files, except 'mysql-in.010'
• B、It deletes all binary log files up to and including 'mysql-bin.010'
• C、It deletes all binary log files before 'mysql-bin.010'
• D、It deletes all binary log files after 'mysql-bin.010'

第17题：

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

第18题：

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

第19题：

第20题：

第21题：

第22题：

第23题：