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

質問 1

Which two statements are true about the mysql_config_editor program? (Choose two.)

（A）It can be used to create and edit SSL certificates and log locations.

（B）It provides an interface to change my.cnf files.

（C）It manages the configuration of client programs.

（D）It can move datadir to a new location.

（E）It will use [client] options by default unless you provide --login-path.

（F）It manages the configuration of the MySQL Firewall feature.

（G）It manages the configuration of user privileges for accessing the server.

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

質問 2

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?

（A）PREFERRED

（B）VERIFY_CA

（C）REQUIRED

（D）VERIFY_IDENTITY

正解：C 解答を投票する

質問 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-10167;

（C）RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

（D）RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

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

質問 4

Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

（A）This file is for storing MySQL server_uuid values only.

（B）This file is for storing MySQL Server configuration options in ISON format.

（C）It is read and processed at the beginning of startup configuration.

（D）This file is for logging purposes only and is never processed.

（E）It is read and processed at the end of startup configuration.

（F）It is always updated with changes to system variables.

正解：E、F 解答を投票する

質問 5

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

（A）named pipes

（B）TCP/IP

（C）UDP

（D）X Protocol

（E）SOCKET

（F）shared memory

正解：A、B、F 解答を投票する

質問 6

You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

（A）Remove ib_logfile0 and ib_logfile1 files from the file system.

（B）Execute mysqladmin flush-logs.

（C）First run mysqld --initialize to refresh the Size of ib_logfile.

（D）Create a new ib_logfile0 file of size 26214400.

正解：C 解答を投票する

質問 7

An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata. Please use the most up to date instance: 'host1:3377'.
(RuntimeError)
Which statement is true?

（A）It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

（B）The instance deployed on host3 must be rebuilt with a backup from the primary instance.

（C）The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').

（D）The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').

（E）The cluster is running and there is at least one ONLINE instance.

正解：C 解答を投票する

質問 8

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）MySQL server continued to start up even though another process existed.

（B）systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

（C）systemd waited for 30 seconds before timing out and start up failed.

（D）MySQL server was not started due to a problem while executing process 2732.

（E）systemd found the mysqld service disabled and failed to start it.

正解：B 解答を投票する

質問 9

Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

（A）The backup operation will finish only when backup-and-apply-log is executed.

（B）A single-file backup is created.

（C）The --backup-dir option holds temporary output, status, and metadata files.

（D）The backup operation will finish only when apply-log is executed.

（E）A raw backup is created.

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

質問 10

Which condition is true about the use of the hash join algorithm?

（A）The query must access no more than two tables.

（B）The smallest of the tables in the join must fit in memory as set by join_buffer_size.

（C）No index can be used for the join.

（D）At least one of the tables in the join must have a hash index.

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験