Oracle 1z0-888 Exam Actual Questions

The questions for 1z0-888 were last updated on July 4, 2024.

Viewing page 1 out of 39 pages.
Viewing questions 1-4 out of 155 questions

Topic 1 - Exam A

Question #1 Topic 1

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?

A. Backup State = Compressed Backup
Operation = copy-back
B. Backup State = Raw Backup -
Operation = apply-log
C. Backup State = Prepared Backup -
Operation = validate
D. Backup State = Prepared Backup -
Operation = apply-log
E. Backup State = Raw Backup -
Operation = backupdir-to-image

Reveal Solution Discussion 1

Correct Answer: E 🗳️

Question #2 Topic 1

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

A. mysqldumpslow
B. mysqldump
C. mysqlaccess
D. mysqlshow
E. mysqlslow

Reveal Solution Discussion

Correct Answer: A 🗳️

Question #3 Topic 1

Consider:

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

A. It shows how many bytes will be used from each index row.
B. It shows the number of characters indexed in the key.
C. It shows the total size of the index row.
D. It shows how many columns in the index are examined.

Reveal Solution Discussion

Correct Answer: A 🗳️

Question #4 Topic 1

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?