Oracle 1z0-888 Exam Actual Questions

You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup
The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

Correct Answer: E 🗳️

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

Correct Answer: A 🗳️

Consider:

Which statement best describes the meaning of the value for the key_len column?

Correct Answer: A 🗳️

Examine the mydata table and SELECT statements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

Correct Answer: D 🗳️