Free Oracle 1Z0-888 Exam Dumps Questions & Answers

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 network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• 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 mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
• E.  The mysql service has already been started on the same port.

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

• A.  --restore=2
• B.  --instance=/var/lib/mysql/instance2
• C.  --copy-back-from-log
• D.  --defaults-file=/etc/mysql/instance2.cnf
• E.  --backup-instance=/var/lib/mysql/instance2

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 allow a backup to be created under reduced load
• D.  to prevent schema changes from propagating to the slave before they are validated
• E.  to prevent any transaction experiencing a deadlock

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

• A.  Both the affected transactions will be rolled back.
• B.  One of the affected transactions will be rolled back, the other is allowed to proceed.
• C.  The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
• D.  The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
• E.  The transaction isolation level determines which transaction is rolled back.

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
Which statement is true?

• A.  The OS needs to allow logging in as mysql so that administrative tasks can be performed.
• B.  This prevents mysqld from starting when standard startup scripts are used.
• C.  The mysql user needs a login and its home directory must be the base directory of the installation.
• D.  This prevents creation of a command shell with the mysql account, while allowing mysqld to run.