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

出題：1

Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

A. John has not activated the role.

B. The DBA needs to execute FLUSH PRIVILEGES.

C. John needs to reconnect to the database.

D. The statement was blocked by MySQL Firewall.

正解：A 解答を投票する

出題：2

Which two statements are true about MySQL Installer? (Choose two.)

A. It performs product upgrades.

B. It provides a uniform installation wizard across multiple platforms.

C. Manual download of separate product packages is required before installing them through MySQL Installer.

D. It installs most Oracle MySQL products.

E. It provides only GUI-driven, interactive installations.

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

出題：3

There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

A. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

B. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

C. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

D. The cluster will shut down to preserve data consistency.

E. A manual intervention to force group members to be only the working two instances is required.

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

出題：4

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

A. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql

B. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

C. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

正解：A 解答を投票する

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

出題：5

Which two methods allow a DBA to reset a user's password? (Choose two.)

A. GRANT statement

B. SET PASSWORD statement

C. mysql_secure_installation utility

D. ALTER USER statement

E. mysqladmin client program

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

出題：6

A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

A. $MYSQL_HOME/my.cnf file

B. $HOME/.mysqlrc file

C. $HOME/.mysql/auth/login file

D. /etc/my.cnf file

E. $HOME/.mylogin.cnf file

F. $HOME/.my.cnf file

G. DATADIR/mysqld-auto.cnf file

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

出題：7

Examine this command, which executes successfully:

Which statement is true?

A. Only InnoDB data and log files are backed up.

B. Only non-encrypted files are backed up.

C. Only tables stored in their own tablespaces are backed up.

D. The backup includes only data files and their metadata.

E. Only files for MySQL or Its built-in storage engines are backed

正解：A 解答を投票する

出題：8

You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)

A. starting and stopping the MySQL instance

B. deploying the MySQL agent on supported target operating system

C. creating e-mail alerts and SNMP traps for MySQL warnings

D. tracing import and export with mysqidump

E. monitoring of NDB Cluster API nodes

F. monitoring the availability of the MySQL instance

G. analyzing executed MySQL queries

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

出題：9

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

A. It returns an error because the mysqldump command should have been used.

B. It creates a logical backup of all metadata, but contains no table data.

C. It creates a logical backup of all MySQL user accounts.

D. It creates a logical backup of only the users database.

正解：C 解答を投票する

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

出題：10

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

A. error log

B. audit log

C. general query log

D. binary log

E. slow query log

正解：D 解答を投票する

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