Oracle MySQL 5.6 Database Administrator - 1z1-883 FREE EXAM DUMPS QUESTIONS & ANSWERS
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?
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?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?
Which two conditions must be true?
Correct Answer: A,B
Vote an answer
Following a server crash, the automatic recovery of InnoDB fails.
How would you begin to manually repair the InnoDB tables?
How would you begin to manually repair the InnoDB tables?
Correct Answer: C
Vote an answer
What are three actions performed by the mysql_secure_installation tool?
Correct Answer: C,D,E
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You want to shutdown a running Mysql Server cleanly.
Which three commands that are valid on either Windows or Linux will achieve this?
Which three commands that are valid on either Windows or Linux will achieve this?
Correct Answer: B,D,F
Vote an answer
You have forgotten the root user account password. You decide to reset the password and execute the following:
Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start - skip-grant tables
Which additional argument makes this operation safer?
Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start - skip-grant tables
Which additional argument makes this operation safer?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You are using the performance Schema to investigate replication on a slave:
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
What is true regarding InnoDB locking?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Which three statements describe how the strict SQL mode provides added security?
Correct Answer: B,D,E
Vote an answer