mysql ocp考试

You have a MySQL client installed on your Linux workstation with a default installation. You have your 

admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2. 1:3306 to connect to the world database.

 Which four options need to be specified to complete this task with a single command? 

Which three are characteristics of a newly created role?

Table t is an InnoDB table. Examine these statements and output: select count(1) from t 

;count(1) = 72 

Mysql show indexes from t \\G 

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

Table: t 

Non_unique:0 

Key_name: PRIMARY 

Seq_in_index:1 

Column_name: a 

Collation:A 

Cardinality:72 

Sub_part:NULL 

Packed:NULL 

Null: 

Index_type:BTREE 

Comment: 

Index_comment: 

Visible:YES 

Expression:NULL 

***************************2.row*************************** 

Table: t 

Non_unique:1 Key_name:b_idx Seq_in_index:1 Column_name:b Collation: A Cardinality:1 

Sub_part: NULL P acked:NULL Null:YES Index_type:BTREE Comment: 

Index_comment: Visible:NO Expression: NULL 

2 row in set (0.00 sec) 

Which two are true? 

 Which two statements are true about the mysqld-auto.cnf file?

Examine this command and output:（见下图）

（含图）

Which two statements are true?

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently. 

Which two sets of actions when completed will accomplish this?

You must run multiple instances of MySQL Server on a single host.

Which three methods are supported? 

Your MySQL installation is running low on space due to binary logs. You need to reduce your log 

space usage urgently. Which two sets of actions when completed will accomplish this?

The replication for master and slave MySQL Server is up and running .The disk space occupied by 

the binary log files continues to grow. Which two methods mange this issue?

You administer a three node, single primary InnoDB Cluster. Examine cluster.status() 

displayed here:"statusText":"Cluster is ONLINE and can tolerate up to ONE failure." 

Which two statements are true?

Which two MySQL Server accounts are locked by default?

Examine this command, which executes successfully:mysqlpump --user=root --password > full_ 

backup.sql 

Which two databases will be excluded from this dump?

Which three commands can report all the current connections running on the MySQL server?

Choose three. Identify three functions of MySQL Enterprise Monitor.

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

Which two statements are true about MySQL server multi-source replication?

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer?

 You must export data from a set of tables in the world_x database. Examine this set of tables: 

Tables (country, countryinfo, location) 

Which two options will export data into one or more files?

Which are three benefits of using mysqlbackup instead of mysqldump?

Choose two. All MySQL Server instances belonging to InnoDB Cluster have SSL configured and 

enabled. You must configure InnoDB Cluster to use SSL for group communication. 

Which two statements are true?