1Z0-908試験無料問題集（142題）「Oracle MySQL 8.0 Database Administrator 認定」

出題：1

Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

A. ADMIN OPTION allows Mark to drop the role.

B. Mark must connect from localhost to activate the r_read@localhost role.

C. Mark can grant the privileges assigned to the r_read@localhost role to another user.

D. Mark can grant the r_read@localhost role to another user.

E. ADMIN OPTION causes the role to be activated by default.

F. Mark can revoke the r_read@localhost role from another role.

正解：D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

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

A. It performs product upgrades.

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

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

D. It installs most Oracle MySQL products.

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

正解：A,E 解答を投票する

出題：3

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 relay logs from the master should be used to replace the corrupted relay logs.

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

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.

正解：A 解答を投票する

出題：4

You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.
[mysql]
innodb_data_file_path=
Which two configurations would satisfy long-term storage demands? (Choose two.)

A. ibdatal:12M

B. ibdatal:12M;ibdata2:12M;ibdata3:12M

C. ibdatal:12M;/tmp/ibdata2:12M:autoextend

D. ibdatal:12M;ibdata2:12M:autoextend

E. ibdatal:12M:autoextend

F. ibdatal:12M:autoextend;ibdata2:12M:autoextend

正解：A,B 解答を投票する

出題：5

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.

正解：D 解答を投票する

出題：6

An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

A. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;

B. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

C. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

D. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

E. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;

F. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency

正解：B,F 解答を投票する

出題：7

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

A. No committed transactions are lost.

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

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

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

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

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

正解：B,C 解答を投票する

出題：8

Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

A. All databases, excluding master metadata, are backed up to the output file.

B. All details regarding deleted logs and master metadata are captured in the output file.

C. All databases are backed up to the output file.

D. All binary logs are deleted from the master.

E. All non-active binary logs are removed from the master.

F. All binary logs are backed up and then deleted.

正解：A,D 解答を投票する

出題：9

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. An error is returned.

B. Only the minimum connection value is increased to 3000.

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

D. The minimum connection value is changed to 2000.

正解：B 解答を投票する

出題：10

Which two statements are true about MySQL server multi-source replication? (Choose two.)

A. It needs to be re-instanced after a crash to maintain consistency.

B. It does not attempt to detect or resolve replication conflicts.

C. It uses only time-based replication conflict resolution.

D. It is not compatible with auto-positioning.

E. It must use GTID replication.

F. It relies on relay_log_recovery for resilient operations.

正解：C,E 解答を投票する

1Z0-908試験無料問題集「Oracle MySQL 8.0 Database Administrator 認定」