Practice 1Z0-888 Exam Online

Question 1

This output is from a SHOW SLAVE STATUS:

Other-Image-21012ebcf-4af1-4a8c-8698-593bba89e0f8

What would cause the SQL_Delay variable to have a value of 360?

A : The master has performed a large transaction, which will take 360 seconds to complete on the slave

B : The network latency between the master and the slave is 360 milliseconds.

C : The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

D : The slave was configured for delayed replication with a delay of six minutes.

Answer: D

Question 2

The Performance Schema includes these tables related to status variables:

Other-Image-2005ee969-7921-41b1-8df4-5791d1b6fb9b

Which two facts are true about these tables? (Choose two.)

A : The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

B : All these tables have the same number of rows.

C : The global_status table is equivalent to the SHOW GLOBAL STATUS statement.

D : The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.

E : The session_status table is equivalent to status_by_thread for the current thread.

Answer: A,D

Question 3

Which two methods accurately monitor the size of your total database size over time? (Choose two.)

A : monitoring the Innodb_rows_inserted status variable

B : monitoring the innodb_redo_log_size variable

C : monitoring the information_schema.TABLES table

D : monitoring datadir size in the operating system

E : monitoring cumulative Innodb_page_size increase

F : monitoring the performance_schema_hosts_size variable

Answer: A,C

Question 4

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?

A : executing REVOKE LOAD FROM *.*

B : setting the --local-service=0 option when starting mysqld

C : executing REVOKE FILE FROM *.*

D : executing REVOKE FILE ON *.* FROM ' ' @'%'

E : setting the --local-infile=0 option when starting mysqld

F : setting the --open-files-limit=0 option when starting mysqld

Answer: A

Question 5

A MySQL database uses all InnoDB tables and is configured as follows;

Other-Image-2e5b2c143-d60d-4e67-bf3f-0d7a78ed2db8

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

A : --skip-opt

B : --lock-all-tables

C : --create-apply-log

D : --single-transaction

E : --master-data

Answer: A,B

Name:	MySQL 5.7 Database Administrator
Exam Code:	1Z0-888
Certification:	Oracle MySQL
Vendor:	Oracle
Total Questions:	125
Last Updated:	Apr 24, 2024

Oracle 1Z0-888