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

出題：1

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

出題：2

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A. replication

B. audit of all queries

C. point-in-time recovery

D. logging the duration and locks for all queries

E. recording the order in which queries are issued

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

出題：3

You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

B. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

C. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

D. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

E. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

正解：E 解答を投票する

出題：4

Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

A. UPDATE world.country SET Name=CONCAT('New ',Name);

B. UPDATE world.country SET Name='one' LIMIT 1;

C. UPDATE world.country SET Name='new' WHERE Name='old';

D. UPDATE world.country SET Name='all';

E. UPDATE world.country SET Name='first' ORDER BY Name LIMIT

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

出題：5

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

出題：6

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

A. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

B. MySQL server continued to start up even though another process existed.

C. MySQL server was not started due to a problem while executing process 2732.

D. systemd found the mysqld service disabled and failed to start it.

E. systemd waited for 30 seconds before timing out and start up failed.

正解：A 解答を投票する

出題：7

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

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

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

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

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

正解：A 解答を投票する

出題：8

Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

A. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

B. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

C. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

D. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

正解：B 解答を投票する

出題：9

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

A. They are converted to a highly compressible binary format.

B. They are required to obtain FIPS security compliance.

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

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

E. The resulting files are easily human readable.

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

出題：10

You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

A. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

B. It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

C. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

D. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

正解：C 解答を投票する

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