Oracle MySQL 5.7 Database Administrator - 1Z1-888 Exam Questions

QUESTION NO: 1
You have just created a replication slave from a backup of the master made with mysqldump:

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.
Which two changes to the process can fix the issue?

QUESTION NO: 2
You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

QUESTION NO: 3
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

QUESTION NO: 4
To query two system variables, you execute this statement and get the results shown:

When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?

QUESTION NO: 5
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system. Which step should you perform before defining your own databases and database tables?

QUESTION NO: 6
Which are three facts about backups with mysqldump?

QUESTION NO: 7
You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?

QUESTION NO: 8
Examine the mydata table and SELECT statements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

QUESTION NO: 9
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

QUESTION NO: 10
Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)

QUESTION NO: 11
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

QUESTION NO: 12
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?