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

出題：1

Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?

A. It has been expelled from the cluster because of a transaction error.

B. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()

C. It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')

D. It has been removed from the cluster by using the command STOP GROUP_REPLICATION;

E. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')

正解：B 解答を投票する

出題：2

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

出題：3

Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

A. employee

B. mysql

C. world

D. sys

E. information_schema

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

出題：4

On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

A. SQL injections could be used to insert bad data into the database.

B. MySQL binaries could be damaged, deleted, or altered.

C. Data files could be deleted.

D. Users could overwrite configuration files.

E. Extra startup time would be required for the MySQL server to reset the privileges.

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

出題：5

Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

A. VERIFY_CA

B. DISABLED

C. VERIFY_IDENTITY

D. REQUIRED

E. PREFERRED

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

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

出題：6

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

A. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

B. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

C. Physical upgrades are much faster because they do not require restarting the mysqld process.

D. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

E. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

F. Logical upgrades are much faster because they do not require restarting the mysqld process.

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

出題：7

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

出題：8

Which two are use cases of MySQL asynchronous replication? (Choose two.)

A. It allows backup to be done on the slave without impacting the master.

B. MySQL Enterprise Backup will automatically back up from an available slave.

C. You can scale writes by creating a replicated mesh.

D. It guarantees near real-time replication between a master and a slave.

E. You can scale reads by adding multiple slaves.

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

出題：9

Examine this command and output:

Which statement is true?

A. Firewall_access_granted is the number of connections granted from whitelisted hosts.

B. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C. Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

D. Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

正解：D 解答を投票する

出題：10

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

A. It restores files from the backup directory to their original MySQL server locations.

B. The copy-back process is used to overwrite a new backup over an existing backup.

C. It restores files from the data directory to their original MySQL server locations.

D. The copy-back process makes inconsistent backups.

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

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