Question No. 1

You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave.

Which procedure would you execute from a MySQL prompt?

AOption A

BOption B

COption C

DOption D

Show Answer

Correct Answer: B

Question No. 2

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

Alog-master-updates

Brpl-recovery-rank

Cserver-id

Denable-master-start

Elog-bin

Fmaster-logging
References:

Show Answer

Correct Answer: C, E

Question No. 3

After rebooting the host, you attempt to start the mysqld service. You get the following error:

Can't start the server: Bind on TCP/IP port: Address already in use

What is the most likely cause of this error?

AThe mysqld service has already been started on the same port.

BThe network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.

CYou failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.

DThe /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.

EThe mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

Show Answer

Correct Answer: E

Question No. 4

A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.

Which two will optimize the security of this setup? (Choose two.)

Aenabling and using SSL for connections to the MySQL database

Brunning the server with ---skip-networking specified

Cdisabling connections from named pipes or socket files (depending on the operating system of the server)

Dstarting the server with ---bind-address=0.0.0.0 specified

Elimiting logins to originate from the application server or the server's subnet

Finstalling MySQL on the application server, and running the database and application on the same server

Show Answer

Correct Answer: A, F

Question No. 5

You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup?

ACheck the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

BCheck the difference between the InnoDB status values ''Log Sequence number'' and ''Last Checkpoint'' positions then compare that to the total size of the redo log.

CCheck the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

DCheck the difference between the InooDB status values ''Trx id counter'' and ''Purge done for'' and compare to the state substatus of the main ''Main thread''

ECheck the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

Show Answer

Correct Answer: B, E

Free Oracle 1Z0-888 Exam Actual Questions

The questions for 1Z0-888 were last updated On Jan 14, 2025