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

Note! Following 1z0-883 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

MySQL 5.6 Database Administrator Questions and Answers

Question 1

You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error:

mysql> CALL film_in_stock (40, 2, @count);

ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) does not exist

How would you identify all stored procedures that pose the same problem?

Options:

A.

Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.

B.

Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.

C.

Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE DEFINER=’bob@localhost’;.

D.

Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER=’bob’ and HOST=’ localhost’;.

E.

Examine the Mysql error log for other ERROR 1449 messages.

Buy Now
Question 2

Consider the Mysql Enterprise Audit plugin.

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

Options:

A.

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

B.

The attribute “PRIV_USER” contains the username.

C.

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

D.

There is no differentiation between native and external authentication events.

E.

External authentication is managed through external auditing logs.

F.

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

Question 3

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:

A.

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

B.

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

C.

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

D.

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