Limited-Time Offer: Enjoy 50% Savings! Ends in 00h 00m 00s Coupon code: 50OFF
Skip to content
Login Sign up

Free Oracle MySQL 8.0 Database Administrator 1Z0-908 Exam Questions

Page: 1 / 14 Total 140 questions

Want more questions? Get Premium Access.

Question 1

Examine this command, which executes successfully:

shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb

Which two statements are true? (Choose two.)

Correct Answer: A. It executes flush tables with read lock.; D. This option uses the READ COMMITTED transaction isolation mode.

Question 2

There are five MySQL instances configured with a working group replication.

Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

Correct Answer: A. The cluster will shut down to preserve data consistency.; B. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

Question 3

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

Correct Answer: D. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';

Question 4

Which two queries are examples of successful SQL injection attacks? (Choose two.)

Correct Answer: D. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;; E. SELECT email,passwd FROM members WHERE email = 'INSERT INTO members('email','passwd') VALUES ('bob@example.com', 'secret');--';

Question 5

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

Correct Answer: B. Data files could be deleted.; E. Extra startup time would be required for the MySQL server to reset the privileges.

Question 6

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Which two statements are true? (Choose two.)

Correct Answer: A. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.; E. The transactions table was created with innodb_file_per_table=OFF.

Question 7

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

Correct Answer: C. Change the group ownership of the mysql directory to the mysql user group.; E. Change the parent directory owner and group to mysql.

Question 8

Examine this command, which executes successfully:

mysqlpump ---user=root --password > full_backup.sql

Which two databases will be excluded from this dump? (Choose two.)

Correct Answer: A. information_schema; D. sys

Question 9

Which two are use cases of MySQL asynchronous replication? (Choose two.)

Correct Answer: C. You can scale reads by adding multiple slaves.; E. It allows backup to be done on the slave without impacting the master.

Question 10

A valid raw backup of the shop.customers MyISAM table was taken.

You must restore the table. You begin with these steps:

1. Confirm that secure_file_priv='/var/tmp'

2. mysql> DROP TABLE shop.customers;

3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/

Which two actions are required to complete the restore? (Choose two.)

Correct Answer: D. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi; G. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
Page: 1 / 14 Total 140 questions