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

出題：1

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

A. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

B. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

C. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

D. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

正解：C 解答を投票する

出題：2

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

出題：3

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

出題：4

Examine this query and its output:

Which two statements are true? (Choose two.)

A. The root user had the largest number of modified rows for a SELECT statement.

B. User bob had the largest total time waiting for locks.

C. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

D. The app user had the highest total number of rows read from storage engines.

E. The root user had the largest single wait time.

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

出題：5

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

A. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

C. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

E. The mysqlcheck --optimize --all-databases command reclaims free space from table files.

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

出題：6

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

出題：7

You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

A. MySQL keeps InnoDB metadata changes in .sdi files in datadir.

B. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

C. MySQL writes SDI to the binary log for distributed backups.

D. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

E. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

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

出題：8

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

出題：9

You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

A. [mysqld]
default_authentication_plugin=caching_sha2_password

B. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';

C. [mysqld]
default_authentication_plugin=mysql_native_password

D. ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password';

E. [mysqld]
default_authentication_plugin=sha256_password

F. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password';

正解：F 解答を投票する

出題：10

Examine this query and output:

Which two statements are true? (Choose two.)

A. It takes more than 8 milliseconds to sort the rows.

B. The query returns exactly 125 rows.

C. The country table is accessed as the first table, and then joined to the city table.

D. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.

E. 35 rows from the city table are included in the result.

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

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