1Z0-908試験無料問題集（142題）「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 will use [client] options by default unless you provide --login-path.

C. It manages the configuration of the MySQL Firewall feature.

D. It manages the configuration of user privileges for accessing the server.

E. It manages the configuration of client programs.

F. It provides an interface to change my.cnf files.

G. It can move datadir to a new location.

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

出題：2

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

出題：3

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

A. table_open_cache

B. innodb_buffer_pool_size

C. sort_buffer_size

D. key_buffer_size

E. read_buffer_size

F. tmp_table_size

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

出題：4

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

A. It adds more temporary workspace in addition to the innodb_tmpdir location.

B. It defines all innodb tablespace options relative to a starting parent directory.

C. It is not necessary because innodb_data_home_dir is already defined.

D. It allows scanning of other locations to discover more innodb tablespaces.

E. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

正解：D 解答を投票する

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

出題：5

You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

A. Roll back the transaction and start the transaction again in the same session.

B. Change the default database and re-execute the failed statement in your transaction.

C. Close the connection, reconnect, and start the transaction again.

D. Re-execute the failed statement in your transaction.

正解：D 解答を投票する

出題：6

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

A. ib_logfile* files

B. *.CSM files

C. ibbackup files

D. *.sdi files

E. *.ibd files

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

出題：7

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

A. Decrease the number of buffer pool instances to 1.

B. Increase the number of buffer pool instances to 12.

C. Decrease the number of buffer pool instances to 4.

D. Increase the number of buffer pool instances to 32.

E. Increase the number of buffer pool instances to 16.

正解：D 解答を投票する

出題：8

How can mysql_multi be configured to allow MySQL instances to use the same port number?

A. The instances use different user accounts unique to each instance.

B. The instances use different socket names.

C. The instances listen on different IP addresses.

D. The instances have appropriate net masks set.

正解：C 解答を投票する

出題：9

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

A. Each slave thread is responsible for updating a specific database.

B. Setting transaction_allow_batching to on will improve data consistency.

C. Increasing slave_parallel_workers will improve high availability.

D. Setting slave_preserve_commit_order to on will improve data consistency.

E. Cross-database constraints can cause database inconsistency.

F. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

正解：D 解答を投票する

出題：10

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 メンバーにのみ表示されます)

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