Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-908 - MySQL 8.0 Database Administrator

Page: 4 / 5
Total 140 questions

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

A.

It executes flush tables with read lock.

B.

It enforces consistent backups for all storage engines.

C.

The backup created is a consistent data dump.

D.

This option uses the READ COMMITTED transaction isolation mode.

E.

It is a cold backup.

What does the binlog dump thread do?

A.

It monitors and schedules the rotation/deletion of the binary logs.

B.

It reads the relay log and executes the events contained in them.

C.

It acquires a lock on the binary log for reading each event to be sent to the slave.

D.

It connects to the master and asks it to send updates recorded in its binary logs.

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A.

MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

B.

Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

C.

Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

D.

TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Examine this query and output:

Which two statements are true? (Choose two.)

A.

The country table is accessed as the first table, and then joined to the city table.

B.

It takes more than 8 milliseconds to sort the rows.

C.

The optimizer estimates that 51 rows in the country table have Continent = ‘Asia’.

D.

35 rows from the city table are included in the result.

E.

The query returns exactly 125 rows.

The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000

The minimum and maximum delays need to be increased to 3000 and 5000, respectively.

A command is executed:

mysql> SET GLOBAL connection_control_min_connection_delay=3000;

What is the result?

A.

The minimum value increases to 3000 and the maximum value increases to 4000.

B.

Only the minimum connection value is increased to 3000.

C.

The minimum connection value is changed to 2000.

D.

An error is returned.

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

A.

The slave relay logs should be deleted; then execute START SLAVE;

B.

The relay logs from the master should be used to replace the corrupted relay logs.

C.

The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D.

The slave needs to be restored from backup.

You have an InnoDB Cluster configured with three servers.

Examine this command, which executes successfully:

mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A.

Stop all instances except the primary read/write master instance and run the restore.

B.

Remove the @@GLOBAL.gtid_purged statement from the dump file.

C.

Create the backup by using the --set-gtid-purged=OFF option.

D.

Remove the group replication plugin from each instance before restoring.

E.

Remove the @@GLOBAL.gtid_executed statement from the dump file.

F.

Restore using the --set-gtid-purged=OFF option.

Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.

You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.

Which command will complete the recovery?

A.

mysqlbinlog --stop-position=500324 binlog.000036 | mysql

B.

mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

C.

mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql

D.

mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

Examine this command, which executes successfully:

Which statement is true?

A.

Only files for MySQL or Its built-in storage engines are backed

B.

Only non-encrypted files are backed up.

C.

The backup includes only data files and their metadata.

D.

Only InnoDB data and log files are backed up.

E.

Only tables stored in their own tablespaces are backed up.

Which two statements are true about raw binary backups? (Choose two.)

A.

They are converted to a highly compressible binary format.

B.

The data format is identical to how MySQL stores the data on disk.

C.

They are required to obtain FIPS security compliance.

D.

The resulting files are easily human readable.

E.

They are faster than logical backups because the process is a simple file or file system copy.