1Z1-888 by Oracle Valid Free Exam Practice Test

Question 1

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?

A. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure. B. The user will get an error because he or she does not have the permission to drop stored procedures. C. The stored procedure named get_reports will be dropped. D. The user will get an error because he or she did not put the database name in front of the stored procedure name.

Correct Answer: C

Question 2

A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

A. binary log, redo log, doublewrite buffer, and tablespace B. redo log, doublewrite buffer, tablespace, and binary log C. redo log, binary log, doublewrite buffer, and tablespace D. doublewrite buffer, redo log, tablespace, and binary log

Correct Answer: A

Question 3

You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:

The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?

A. Change permissions on /var/log/mysqld.log to allow writes. B. Use --no-defaults to ignore the existing config file in the default PATH. C. Pass --log-error=/var/lib/mysql_QA/mysqld.log. D. Use mysql_install_db.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

A. The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name. B. The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name. C. The session_statustable is equivalent to status_by_threadfor the current thread. D. All these tables have the same number of rows. E. The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.

Correct Answer: B,C

Question 5

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4.
Which backup method would you use to reload the corrupted InnoDB tables?

A. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table B. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables C. A text backup. InnoDB does not allow you to make binary backups while the server is running. D. A text backup. A binary backup will still contain the corrupted segments.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords. Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

A. CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman'; B. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman'; C. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman'; D. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman'; E. CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
`imbatman'; F. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
`imbatman';

Correct Answer: B,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

Which three tasks are handled by the optimizer?

A. Parse the query. B. Change the order in which the tables are joined. C. Decide which indexes to use. D. Rewrite the WHERE clause. E. Validate the query. F. Execute the query. G. Verify that the user is allowed to execute the query.

Correct Answer: A,D,F

Question 8

Which three statements correctly describe MySQL InnoDB Cluster?

A. It provides fully synchronous replication between the nodes. B. Each query will be executed in parallel across the nodes. C. All MySQL client programs and connectors can be used for executing queries. D. There is support for automatic failover when one node fails. E. The cluster can be operated in multimaster mode with conflict detection for DML statements. F. The data is automatically shared between the nodes.

Correct Answer: B,C,D

Question 9

Exhibit:

What does the possible_keys column in this output denote?

A. whether there are any indexes on the tables that you are querying B. if it is possible for you to include any indexes in your query C. whether there are any indexes in your query D. if there are any indexes that may be used to solve this query

Correct Answer: B

Question 10

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a raw backup in this way?

A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup. B. The snapshots take a significant amount of disk space because they are a duplicate copy of the data. C. The system keeps a copy of changes in memory and can cause an out-of-memory event. D. The snapshot size will continue to grow as changes to the volume are made.

Correct Answer: B

Question 11

The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

A. MySQL starts and Binary Logging is enabled. B. MySQL fails to start due to conflicting options on the command line. C. MySQL fails to start due to the conflicting options in the configuration files. D. MySQL starts but Binary Logging is disabled.

Correct Answer: B

Oracle MySQL 5.7 Database Administrator - 1Z1-888 Exam Practice Test