Free Oracle 1Z0-888 Exam Dumps Questions & Answers

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 install plugin command for the mysql_cleartext_password plugin
• B.  the mysql client with the --ignore-password-hashing option
• C.  the mysql_upgrade script
• D.  the mysql_secure_installation script to update server security settings
• E.  the mysql client with the --enable-cleartext-plugin option

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

• A.  You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
• B.  The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
• C.  Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
• D.  The statement would fail because you cannot update more than one row at a time when using ?
  binlogformat = ROW.
• E.  Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

The MySQL instance is a default RPM installation on a Linux server.
Where are the errors written?

• A.  no logging enabled by default
• B.  in the syslog daemon on the server
• C.  in the /var/log/mysqld.err file
• D.  in the /var/lib/mysql/hostname.log file

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.  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.
• B.  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.
• C.  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.
• D.  The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• E.  The mysql service has already been started on the same port.

You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?

• A. 
• B. 
• C. 
• D.