1Z0-888試験無料問題集（155題）「Oracle MySQL 5.7 Database Administrator 認定」

出題：1

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

A. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

B. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

C. It results in a syntax error because you cannot specify more than one partition in the same statement.

D. All data in p1 and p3 partitions is removed and the table definition is changed.

正解：B 解答を投票する

出題：2

You want to dump only data from the userdata table.
Which mysqldump command argument is required to accomplish this?

A. --data-only as this specifies that only data is to be dumped

B. --table=userdata in order to dump only the data from the userdata table

C. --no-create-info to skip writing CREATE TABLE statements

D. --single-transaction as this obtains a consistent view of data only

正解：D 解答を投票する

出題：3

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

A. Deactivate the query cache.

B. Increase the value of the innodb_read_io_threads option.

C. Increase the size of the InnoDB buffer pool.

D. Change the table to use HASH indexes instead of BTREE indexes.

E. Increase the value of the innodb_lock_wait_timeout option.

F. Set the value of innodb_adaptive_hash_index to zero.

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

出題：4

Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)

A. Only the password for active account can be changed.

B. All users have unrestricted access.

C. All connections succeed regardless of the username and password.

D. MySQL becomes read-only except for setting passwords.

E. User authentication is based on the operating system username.

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

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

出題：5

Which statement best describes a "warm" backup?

A. It backs up the binary log, which contains the most recent "warm" changes.

B. It is similar to a "hot" backup, but differs in that it does not permit write operations.

C. It is similar to a "cold" backup, but differs in that it permits write operations.

D. It only backs up "warm" data, that is, data that has been recently modified.

正解：D 解答を投票する

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

出題：6

MySQL is installed on a Linux server and has this configuration:
[mysqld]
user=mysql
datadir=/data/mysql/
As the 'root' user, you change the datadir location by executing:
shell> cp -R /var/lib/mysql /data/mysql/
shell> chown -R mysql /data/mysql
What is the purpose of changing ownership of datadirto the 'mysql' user?

A. The mysqld process requires all permissions within datadir to be the same.

B. MySQL requires correct file ownership while remaining secure.

C. MySQL needs to be run as the root user, but files cannot be owned by it.

D. MySQL cannot be run as the root user.

正解：B 解答を投票する

出題：7

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

B. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

C. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

D. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

正解：D 解答を投票する

出題：8

What is the order of tables shown in an EXPLAIN output?

A. It lists tables from the smallest to the largest.

B. It lists tables from the most optimized to the least optimized.

C. It lists tables in the order in which they are specified in the statement that is being explained.

D. It lists tables in the order in which their data will be read.

正解：C 解答を投票する

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

出題：9

Which three statements correctly describe MySQL InnoDB Cluster?

A. There is support for automatic failover when one node fails.

B. The cluster can be operated in multimaster mode with conflict detection for DML statements.

C. It provides fully synchronous replication between the nodes.

D. The data is automatically shared between the nodes.

E. Each query will be executed in parallel across the nodes.

F. All MySQL client programs and connectors can be used for executing queries.

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

出題：10

This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?

A. The network latency between the master and the slave is 360 milliseconds.

B. The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

C. The slave was configured for delayed replication with a delay of six minutes.

D. The master has performed a large transaction, which will take 360 seconds to complete on the slave.

正解：C 解答を投票する

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

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