You plan to install MySQL Server by using the RPM download.

Which two statements are true?

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

Which two storage engines provide a view of the data consistent with the storage system at any moment?

You want to log only the changes made to the database objects and data on the MySQL system.

Which log will do this by default?

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

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

Examine this statement:

mysql>DROP ROLE r_role1, r_role2 ;

Which two are true?

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

Examine this statement and output:

mysql> SHOW GRANTS FOR jsmith;

Grants for jsmith@%

GRANT USAGE ON *.* TO 'jsmith'@'%'

GRANT UPDATE (Name) ON 'world.country' TO 'jsmith'@'%';

2 rows in set (0.00 sec)

Which two SQL statements can j smith execute?

Which three sets of item information are visible in the mysql system database?

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?

Examine this parameter setting:

audit_log=FORCE_LOG_PERMANENT

What effect does this have on auditing?

You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

User account baduser@hostname on your MySQL instance has been compromised.

Which two commands stop any new connections using the compromised account?

Which two MySQL Server accounts are locked by default?

Which three statements are true about MySQL Enterprise Firewall?