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?
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?
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?
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?
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?
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?
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?
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
0
0
0
10