Pass4itsure > Oracle > Oracle Database > 1Z0-888 > 1Z0-888 Online Practice Questions and Answers

1Z0-888 Online Practice Questions and Answers

Questions 4

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

Buy Now
Questions 5

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

A. It caches index blocks for MyISAM tables only.

B. It caches index blocks for all storage engine tables.

C. It is a global buffer.

D. It is set on a per-connection basis.

E. It caches index blocks for InnoDB tables only.

Buy Now
Questions 6

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. binlog_cache_size=1024 is too small and transactions are lost.

B. binlog_format=STATEMENT and a non-deterministic query was executed.

C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

D. The sync_relay_log=1000 setting on the slave is too small.

E. sync_binlog=0 and the master server crashed.

Buy Now
Questions 7

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.

Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

A. Install the X509 plug-in on the server.

B. Set the X509 option in the [client] section of the MySQL server's configuration file.

C. Restart the server with the --require-x509 option.

D. Distribute client digital certificates to the client computers being used to log in by the user accounts.

E. Provide users access to the server's private key.

Buy Now
Questions 8

Consider the table people with the definition:

The application uses a query such as:

SELECT * FROM people WHERE YEAR(Birthday) = 1980;

The query is not using an index.

Which two methods can be used to allow the query to use an index? (Choose two.)

A. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

B. Add a functional index for YEAR(Birthday).

C. Execute ANALYZE TABLE to update the index statistics.

D. Add a generated column calculating YEAR(Birthday) and index that column.

E. Add FORCE INDEX (Birthday) to the query.

Buy Now
Questions 9

This output is from a SHOW SLAVE STATUS:

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.

Buy Now
Questions 10

A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERT statement commits. Which list of locations is in the sequence of disk writes for this transaction?

A. binary log, redo log, doublewrite buffer, and tablespace

B. redo log, binary log, doublewrite buffer, and tablespace

C. doublewrite buffer, redo log, tablespace, and binary log

D. redo log, doublewrite buffer, tablespace, and binary log

Buy Now
Questions 11

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4. Which backup method would you use to reload the corrupted InnoDB tables?

A. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

B. A text backup. A binary backup will still contain the corrupted segments.

C. A text backup. InnoDB does not allow you to make binary backups while the server is running.

D. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

Buy Now
Questions 12

At which stage during query processing does MySQL create a query's execution plan?

A. Optimizing

B. Parsing

C. Executing

D. Authorizing

Buy Now
Questions 13

You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.

Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.

You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.

What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

A. 10% CPU

B. 90% RAM

C. 9.1 five minute load average, 10% iowait

D. 100% CPU use, 50% RAM

E. 100% iowait

F. 100% SWAP, 100% RAM

Buy Now
Exam Code: 1Z0-888
Exam Name: MySQL 5.7 Database Administrator
Last Update: Mar 19, 2024
Questions: 155
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$45.99

VCE

$49.99

PDF + VCE

$59.99