1z0-908 Oracle Exam Lab Questions

MySQL 8.0 Database Administrator Questions and Answers

Question 13

Which two methods allow a DBA to reset a user's password? (Choose two.)

Options:

ALTER USER statement

mysql_secure_installation utility

SET PASSWORD statement

mysqladmin client program

GRANT statement

Question 14

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

Options:

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions

will free up disk space.

Executing ALTER TABLE transactions will enable you to free up disk space.

Truncating the sales and leads table will free up disk space.

Truncating the transactions table will free up the most disk space.

The transactions table was created with innodb_file_per_table=OFF.

Question 15

Four nodes are configured to use circular replication.

Examine these configuration parameters for each node:

Which statement is true?

Options:

Each slave thread is responsible for updating a specific database.

Cross-database constraints can cause database inconsistency.

Increasing slave_parallel_workers will improve high availability.

Setting slave_preserve_commit_order to on will improve data consistency.

Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

Setting transaction_allow_batching to on will improve data consistency.

Question 16

You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.

You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.

Which two statements are true? (Choose two.)

Options:

No committed transactions are lost.

The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.

A small amount of committed transactions may be lost in case they were committed just before the disk failure.

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

MySQL 8.0 Database Administrator Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer: