Your MySQL server was upgraded from an earlier major version.The sales database contains three tables, one of which is the transactions table, which has 4 million rows. You are running low on disk space on the datadi r partition and begin to investigate. Examine these commands and output:（见图片）

Which two statements are true?（含图）

['title', 'EXPLAIN']（含图）

A newly deployed replication master database has a 10/90 read to write ratio. The complete dataset is currently 28G but will never fluctuate(波动) beyond +-10%.The database storage system consists of two locally attached PCI- E Enterprise grade disks (mounted as /data1 and /data2)The server is dedicated to this MySQL Instance. System memory capacity is 64G.The my.cnf file contents are displayed here:

[mysqld]

datadir=/data1/ innodb_buffer_pool_size=28G innodb_log_file_size=150M

Which four changes provide the most performance improvement, without sacrificing(牺牲) data integrity?

You must store connection parameters for connecting a Linux-based MySQL client to a remote Windows-based MySQL server listening on port 3309.

Which four methods can be used to configure user, host, and database parameters?

Examine this statement, which executes successfully:

CREATE TABLE employees ( emp_no int unsigned NOT NULL, birth_date date NOT NULL, first_name varchar(14) NOT NULL, last_name varchar(16) NOT NULL, hire_date date NOT NULL, PRIMARY KEY (emp_no))ENGINE=InnoDB;

Now examine this query: SELECT emp_no, first_name, last_name, birth_date FROM employeesWHERE MONTH (birth_date) = 4;

You must add an index that can reduce the number of rows processed by the query. 

Which two statements can do this?

Which two queries are examples of successful SQL injection attacks?

Which two tools are available to monitor the global status of InnoDB locking?

Which two authentication plugins require the plain text client plugin for authentication to work?

Which three are types of information stored in the MySQL data dictionary?

Which four are types of information stored in the MySQL data dictionary?

Examine this SQL statement:

mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION; 

Which two are true?

Which two statements are true about general tablespaces?

Which three methods are part of a 'scale up' approach to capacity planning?

A user wants to connect without entering his or her username and password on the Linux command prompt. Which three locations can be used to store the user's m ysql credentials to satisfy this requirement?