mysql ocp考试(1)

mysqld --initialize command. Which two will assist in locating the root password?

Choose two. Identify two ways to significantly improve data security

Which three methods display the complete table definition of an InnoDB table?

Which two statements are true about the mysql_config_editor program?

 A MySQL server is monitored using MySQL Enterprise Monitor 's agentless installation. 

Which three features are available with this installation method?

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

 Examine this statement:mysql>DROP ROLE r_role1, r_role2 ; Which two are true?

Which two are true about differences between logical and physical upgrades of MySQL databases?

Choose two.On examination, your MySQL installation datadir has become recursively world 

read/write/ executable. What are two major concerns of running an installation with incorrect 

file privileges?

You made some table definition changes to a schema in your MySQL Server. 

Which two statements reflect how MySQL Server handles the table definition changes?

Which three settings control global buffers shared by all threads on a MySQL server?

are true?

Which two MySQL Server accounts are locked by default?

Which three local connection protocols are available to you?

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

Choose two. Which two statements are true about the data dictionary object cache?

Examine this statement, which executes successfully:CREATE USER mary@192.0.2.100 IDENTIFIED BY 'P@SSw0rd' REQUIRE NONE PASSWORD EXPIRE; 

Which two are true?

Choose two. Examine this command, which executes successfully on InnoDB 

Cluster:dba.dropMetadataschema () Which two statements are true?