Download Oracle.1z0-888.CertKiller.2019-12-23.50q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-888 |
| Exam Name: | MySQL 5.7 Database Administrator |
| Date: | Dec 23, 2019 |
| File Size: | 1 MB |
Demo Questions
Question 1
Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?
- mysqldumpslow
- mysqldump
- mysqlaccess
- mysqlshow
- mysqlslow
Correct answer: A
Question 2
Consider:
Which statement best describes the meaning of the value for the key_len column?
- It shows how many bytes will be used from each index row.
- It shows the number of characters indexed in the key.
- It shows the total size of the index row.
- It shows how many columns in the index are examined.
Correct answer: A
Question 3
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?
- one
- one row and a next-key lock for supremum
- one row and a gap-lock
- five
Correct answer: D
