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 

datadir partition and begin to investigate. Examine these commands and output:（见图片） 

Which two statements are true?

（含图）

Choose four. 

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?

Which two actions will secure a MySQL server from network-based attacks?

Choose four. 

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

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

Choose two. 

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?

Choose two. 

Which two queries are examples of successful SQL injection attacks?

Choose two. 

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

Choose two. 

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 dictionar

Choose four。 

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

Choose two. 

Examine this SQL statement: 

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

Which two are true?

Choose two. 

Which two statements are true about general tablespaces?

scale up 垂直扩展 在现有服务器中增加硬件资源，以提高性能和处理能力 

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

Choose three. 

 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?

choose two. 

Examine the modified output:mysql> SHOW SLAVE STATUS \\G 

******************1. row******************** 

Slave_IO_Running:Yes 

Slave_SQL_Running:Yes 

Seconds_Behind_Master:1612 

Seconds_Behind_Master value is steadily growing. 

What are two possible causes?

Oracle Linux 7. 

Which three are valid methods that will shut down the MySQL server?

Examine this MySQL Shell command：dba.rebootClusterFromCompleteOutage () 

Which two statements are true?

Examine this command and output:（见下图） Which two options will improve the security of the MySQL instance?

（含图）