A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
B.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
C.Drop the run_2 index because it has caused a conflict in the choice of key for this query
D.Execute the run_2 index because it has caused a conflict in the choice of key for this query
E.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index

A.It prompts you to set the root user account password
B.It checks whether file permissions are appropriate within datadir
C.It asks to remove the test database, which is generated at installation time
D.It can delete any anonymous accounts
E.It verifies that all users are configuration with the longer password hash

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

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

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

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

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

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

A.The auto-increment lock can be a table-level lock
B.InnoDB never uses table-level locks
C.Some settings for innodb_autoinc_lock_mode can help reduce locking
D.InnoDB always protects auto-increment updates with a table-level lock

A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
B.Execute the PURGE BINARY LOGE NOT USED command
C.Remove all of the binary log files that have a modification date earlier than today
D.Edit the .index file to remove the files you want to delete
E.Ensure that none of the attached slaves are using any of the binary logs you want to delete