Free Online Oracle 1Z0-888 Practice Test

Prepare Your Oracle 1Z0-888 Exam Questions with Free online 1Z0-888 Practice Test. Get Brilliant MySQL 5.7 Database Administrator Exam Results with Valid 1Z0 888 Exam Dumps.

Page: 1 / 25

Total 125 Questions | Updated On: Apr 24, 2024

Question 1

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 2

Consider:

Other-Image-27e18e2aa-4a53-4473-9634-03ec3a7131fa

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.

Answer: A

Question 3

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 4

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

Question 5

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

A : Key Buffer Size

B : InnoDB Redo Log Size

C : Binary Log Size

D : Buffer Pool Size

E : Sort Buffer size

F : Query Cache Size

Answer: A

Page: 1 / 25

Total 125 Questions | Updated On: Apr 24, 2024