Weekend 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

Consider the query:

Mysql> SET @run = 15;

Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)

FROM iteminformation

WHERE run=@run AND objective=’7.1’

GROUP BY objective,stage

ORDER BY stage;

The iteminformation table has the following indexes;

Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.

What is the primary improvement that can be made for this scenario?

Options:

A.

Execute the run_2 index because it has caused a conflict in the choice of key for this query.

B.

Drop the run_2 index because it has caused a conflict in the choice of key for this query.

C.

Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.

D.

Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.

E.

Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

Buy Now
Question 2

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.

Question 3

Consider the events_% tables in performance Schema.

Which two methods will clear or reset the collected events in the tables?

Options:

A.

Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;

B.

Using the statement RESET PERFORMANCE CACHE;

C.

Using the statement FLUSH PERFORMANCE CACHE;

D.

Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;

E.

Disabling and re-enabling all instruments

F.

Restarting Mysql