Free Oracle 1Z0-888 Exam Dumps Questions & Answers

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.)

• A.  disabling connections from named pipes or socket files (depending on the operating system of the server)
• B.  installing MySQL on the application server, and running the database and application on the same server
• C.  limiting logins to originate from the application server or the server's subnet
• D.  starting the server with -bind-address=0.0.0.0 specified
• E.  enabling and using SSL for connections to the MySQL database
• F.  running the server with -skip-networking specified

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.  Deactivate the query cache.
• D.  Change the table to use HASH indexes instead of BTREE indexes.
• E.  Increase the value of the innodb_read_io_threads option.
• F.  Increase the size of the InnoDB buffer pool.

Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

• A.  The mysqld instance has not been restarted after creating the login path.
• B.  The .mylogin.cnf file is not readable.
• C.  There is no password defined in the login path.
• D.  The DNS is not configured correctly for slave1 host.
• E.  The host on the command line is not defined in the login path.

You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?

• A.  When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
• B.  When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
• C.  You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
• D.  When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.

Which are three facts about backups with mysqldump?

• A.  can back up a remote database server
• B.  will lock all storage engines for duration of backup
• C.  create automatically compressed backups
• D.  are able to back up specific items within a database
• E.  allow a consistent backup to be taken
• F.  are always faster to restore than binary backups