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

QUESTION NO: 1
To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

Correct Answer: E
QUESTION NO: 2
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?

Correct Answer: C
QUESTION NO: 3
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?

Correct Answer: D
QUESTION NO: 4
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?

Correct Answer: B
QUESTION NO: 5
You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave.
Which procedure would you execute from a MySQL prompt?

Correct Answer: A
QUESTION NO: 6
Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?

Correct Answer: A
QUESTION NO: 7
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.)

Correct Answer: C,E
QUESTION NO: 8
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?

Correct Answer: B
QUESTION NO: 9
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?
(Choose two.)

Correct Answer: A,D
QUESTION NO: 10
Which are three facts about backups with mysqldump? (Choose three.)

Correct Answer: B,C,F

QUALITY AND VALUE

Actual4test Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.

Tested and Approved

We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.

Easy to Pass

If you prepare for the exams using our Actual4test testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.

Try Before Buy

Actual4test offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.