1z0-888 Oracle Exam Questions and Free Practice Test

Question 13

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?

A. The mysql service has already been started on the same port.

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

C. You 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.

D. The /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.

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

Correct Answer:E

Question 14

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.
1Z0-888 dumps exhibit
What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

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

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

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

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

E. to prevent any transaction experiencing a deadlock

Correct Answer:BC

Question 15

Which three tasks are handled by the optimizer?

A. Decide which indexes to use.

B. Rewrite the WHERE clause.

C. Parse the query.

D. Change the order in which the tables are joined.

E. Validate the query.

F. Execute the query.

G. Verify that the user is allowed to execute the quer

Correct Answer:BCF

Question 16

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

A. mysql --protocol=PLAIN –uroot –p –h dbhost.example.com

B. INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;

C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

D. SET GLOBAL mysql_cleartext_passwords=1;

E. mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

Correct Answer:DE

START 1z0-888 EXAM