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

出題：1

Which three requirements must be enabled for group replication? (Choose three.)

A. replication filters

B. slave updates logging

C. primary key or primary key equivalent on every table

D. binary log MIXED format

E. binary log checksum

F. binary log ROW format

G. semi-sync replication plugin

正解：C,D,G 解答を投票する

出題：2

Which three sets of item information are visible in the mysql system database? (Choose three.)

A. information about table structures

B. audit log events

C. help topics

D. rollback segments

E. plugins

F. performance monitoring information

G. time zone information and definitions

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

出題：3

Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

A. NDB

B. MEMORY

C. ARCHIVE

D. InnoDB

E. MyISAM

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

出題：4

You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?

A. session_variables

B. global_variables

C. variables_by_thread

D. user_variables_by_thread

正解：A 解答を投票する

出題：5

Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

A. It fails if at least one of the roles does not exist.

B. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

C. Existing connections can continue to use the roles' privileges until they reconnect.

D. It fails if any of the roles is specified in the mandatory_roles variable.

E. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

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

出題：6

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 解答を投票する

出題：7

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-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

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

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

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

正解：B 解答を投票する

出題：8

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 解答を投票する

出題：9

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 解答を投票する

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