What are three actions performed by the mysql_secure_installation tool?（）

多项选择题In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）

A.Syntax when writing queries involving JOINS
B.Memory usage when working with the data 
C.Character set mapping index hash size
D.Disk usage when storing data

单项选择题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

多项选择题What are four capabilities of the mysql client program?（）

A.Creating, dropping, and modifying tables and indexes
B.Initiating a binary backup of the database by using the START BACKUP command
C.Displaying replication status information
D.Shutting down the server by using the SHUTDOWN command
E.Creating and dropping databases
F.Creating and administering users

多项选择题Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）

A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B.Using the statement RESET PERFORMANCE CACHE
C.Using the statement FLUSH PERFORMANCE CACHE
D.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E.Disabling and re-enabling all instruments
F.Restarting Mysql

单项选择题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