MySQL 8.0 Database Administrator (1Z0-908) Free Practice Test

Question 1

On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

A. Users could overwrite configuration files.

B. SQL injections could be used to insert bad data into the database.

C. Extra startup time would be required for the MySQL server to reset the privileges.

D. Data files could be deleted.

E. MySQL binaries could be damaged, deleted, or altered.

Correct Answer: C,D

Question 2

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

A. It allows scanning of other locations to discover more innodb tablespaces.

B. It adds more temporary workspace in addition to the innodb_tmpdir location.

C. It defines all innodb tablespace options relative to a starting parent directory.

D. It is not necessary because innodb_data_home_dir is already defined.

E. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

Correct Answer: A

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

Question 3

Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is at the metadata object level.

B. The lock is a row-level lock.

C. The lock is a shared lock.

D. The lock is an intentional lock.

E. The lock is an exclusive lock.

F. The lock is at the table object level.

Correct Answer: B,E

Question 4

You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

A. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

B. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

C. It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

D. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

Correct Answer: A

Question 5

Which two statements are true about MySQL Installer? (Choose two.)

A. It performs product upgrades.

B. Manual download of separate product packages is required before installing them through MySQL Installer.

C. It provides only GUI-driven, interactive installations.

D. It installs most Oracle MySQL products.

E. It provides a uniform installation wizard across multiple platforms.

Correct Answer: A,C

Question 6

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.

B. Use mysql_config_editor to create an encrypted file.

C. Use mysql_secure_installation to encrypt stored login credentials.

D. Use the AES_ENCRYPT() MySQL function on the option file.

Correct Answer: B

Question 7

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

A. Run mysqld with --datadir defined for each instance.

B. Use resource groups to lock different instances on separate CPUs.

C. Run MySQL Server docker containers.

D. Use systemd with different settings for each instance.

E. Start mysqld or mysqld_safe using different option files for each instance.

F. Use system tools to lock each instance to its own CPU.

Correct Answer: A,D,E

Question 8

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

A. --host=192.0.2.1

B. --password

C. --database=world

D. --protocol=pipe

E. --shared-memory-base-name=world

F. --port=3306

G. --protocol=UDP

H. --socket=/tmp/mysql.sock

I. --user=admin

Correct Answer: A,B,D,E

Welcome to TestSimulate

Oracle MySQL 8.0 Database Administrator (1Z0-908) Free Practice Test