1Z0-888 by Oracle Actual Free Exam Questions And Answers

Question 1

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

A. Increase the value of the innodb_lock_wait_timeout option.

B. Set the value of innodb_adaptive_hash_index to zero.

C. Increase the size of the InnoDB buffer pool.

D. Increase the value of the innodb_read_io_threads option.

E. Change the table to use HASH indexes instead of BTREE indexes.

F. Deactivate the query cache.

Discussion 0

Correct Answer: C,D Vote an answer

Question 2

You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?

A. mysqld --initialize ...

B. mysqld_safe --user=mysql

C. mysql -u root -p < support-files/mysqldb.sql

D. service mysqld prepare-init

E. mysqld_safe --initialize ...

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

You want to dump only data from the userdata table.
Which mysqldump command argument is required to accomplish this?

A. --data-only as this specifies that only data is to be dumped

B. --table=userdata in order to dump only the data from the userdata table

C. --no-create-info to skip writing CREATE TABLE statements

D. --single-transaction as this obtains a consistent view of data only

Discussion 0

Correct Answer: D Vote an answer

Question 4

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a `SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

A. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";

B. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

C. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";

D. SET GLOBAL enforce_gtid_consistency=ON

E. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

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 = Prepared Backup
Operation = validate

B. Backup State = Raw Backup
Operation = backupdir-to-image

C. Backup State = Compressed Backup
Operation = copy-back

D. Backup State = Prepared Backup
Operation = apply-log

E. Backup State = Raw Backup
Operation = apply-log

Discussion 0

Correct Answer: B Vote an answer

Question 6

You are looking at these details:

Why does the message "Waiting for an event from Coordinator" show up on the slave_worker threads?

A. The binary log on the master is not being updated.

B. The slave thread is waiting for another event to finish in another slave thread.

C. The Event Schedular is not enabled on the slave host.

D. The slave is waiting for an event to come into the relay log.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
"permissive".
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

A. 3302

B. 3301

C. 3304

D. 3303

Discussion 0

Correct Answer: B Vote an answer

Question 8

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 text backup. A binary backup will still contain the corrupted segments.

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

How does the InnoDB storage engine handle deadlocks when they are detected?

A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

B. The transaction isolation level determines which transaction is rolled back.

C. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

D. One of the affected transactions will be rolled back, the other is allowed to proceed.

E. Both the affected transactions will be rolled back.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?

A. It provides means to help avoid accidentally exposing the MySQL login details.

B. A .mylogin.cnf file can store at most one login path.

C. mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

D. It provides a FIPS-compliant keyring for storing MySQL login details.

E. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

F. It is an alternative to storing the MySQL login details in a my.cnf file.

Discussion 0

Correct Answer: A,F Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 11

Consider a replication setup where a snapshot of the replication status shows:

Which statement is true?

A. The melbourne channel is keeping up with the received events.

B. The last event received from the sydney channel was at 2018-05-08 14:55:01.

C. The melbourne channel is resolving a GTID conflict.

D. The sydney channel is keeping up with the received events.

E. The replication slave uses multisource replication with eight sources.

Discussion 0

Correct Answer: E Vote an answer

Question 12

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

A. to allow for point-in-time recovery on the slave

B. to allow the remaining events to be processed on the slave while not receiving new events from the master

C. to prevent any transaction experiencing a deadlock

D. to prevent schema changes from propagating to the slave before they are validated

E. to allow a backup to be created under reduced load

Discussion 0

Correct Answer: A,E Vote an answer

Question 13

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

A. the mysql client with the --enable-cleartext-plugin option

B. the mysql_upgrade script

C. the mysql client with the --ignore-password-hashing option

D. the mysql_secure_installation script to update server security settings

E. the install plugin command for the mysql_cleartext_password plugin

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 14

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

A. mysqlaccess

B. mysqldump

C. mysqldumpslow

D. mysqlslow

E. mysqlshow

Discussion 0

Correct Answer: C Vote an answer

Question 15

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

A. The slave is configured with slave_parallel_workers = 4

B. THREAD_ID 21 has stopped running.

C. At most, two schemas are being updates concurrently.

D. The slave cannot process the relay log fast enough to use all threads.

E. The salve has two intermediate relay slaves connected to it.

F. The server needs more cores to use all slave threads.

Discussion 0

Correct Answer: A,D Vote an answer

Oracle MySQL 5.7 Database Administrator - 1Z0-888 Exam Practice Test

Contact Us

Useful Links

Latest Updated