A.Syntax when writing queries involving JOINSB.Memory u……

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

单项选择题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 logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event