Exactprep 1z0-883 Questions

MySQL 5.6 Database Administrator Questions and Answers

Question 9

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.

You test whether the import was successful by using the following commands:

Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)

Mysql> show grants for ‘admin’@’%’;

ERROR 1141 (42000): There is no such grant defined for user ‘admin’ on host ‘%’

Which command will fix this issue?

Options:

CREATE USER ‘admin’ @’%’;

GRANT USAGE ON *.* TO ‘admin’@’%’;

FLUSH PRIVILEGES;

FLUSH HOST CACHE;

UPDATE mysql.user SET Create_user_priv = ‘Y’ WHERE user= ‘admin’;

Question 10

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

Options:

Mysql Enterprise Backup

Mysqldump with – binary-data option

Mysqlhotcopy

File system snapshots

Mysqldumpslow

Question 11

Consider the Mysql Enterprise Audit plugin.

Which statement is true when you identify a connection event that has used external authentication?

Options:

The attribute “STATUS” is set to the string EXTERNAL_AUTH.

The attribute “PRIV_USER” contains the username.

The event type that is given in the attribute “NAME” is EXTERNAL_AUTH.

There is no differentiation between native and external authentication events.

External authentication is managed through external auditing logs.

The “PROXY_PRIV” user shows a username if external authentication is used.

Question 12

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.

C: \> mysqld – install Mysql56 – defaults – file = C : \my –opts.cnf

What is the expected outcome?

Options:

Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file.

Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file

An error message is issued because – install is not a valid option for mysqld.

A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf.

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

MySQL 5.6 Database Administrator Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce