1Z0-888問題集、Oracle実際の試験問題

質問 1

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

A. --defaults-file=/etc/mysql/instance2.cnf

B. --copy-back-from-log

C. --instance=/var/lib/mysql/instance2

D. --backup-instance=/var/lib/mysql/instance2

E. --restore=2

正解: A

質問 2

You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords. Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

A. CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman';

B. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman';

C. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
`imbatman';

D. CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
`imbatman';

E. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';

F. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';

正解: E,F

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

質問 3

A general purpose MySQL instance is configured with the following options:
--slow-query-log
--long-query-time=.0001
--log-queries-not-using-indexes
--log-slow-admin-queries
--general-log
--log-bin
--binlog-format=STATEMENT
--innodb-flush-log-at-trx-commit=1
Which three statements are true for most workloads? (Choose three.)

A. The Binary Log records more data than the General Query Log.

B. The General Query Log records more data than the Slow Query Log.

C. The Binary Log records more data than the Slow Query Log.

D. The General Query Log records more data than the Binary Log.

E. The Slow Query Log records more data than the Binary Log.

F. The Slow Query Log records more data than the General Query Log.

正解: B,D,E

質問 4

This output is from a SHOW SLAVE STATUS:

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

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

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 network latency between the master and the slave is 360 milliseconds.

正解: C

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

質問 5

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a raw backup in this way?

A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.

B. The snapshot size will continue to grow as changes to the volume are made.

C. The system keeps a copy of changes in memory and can cause an out-of-memory event.

D. The snapshots take a significant amount of disk space because they are a duplicate copy of the data.

正解: D

質問 6

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

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

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

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

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

正解: C

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

質問 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. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

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

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

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

正解: D

質問 8

You have a scheduled task on Linux that executes mysqldumpagainst the localhost server periodically.
When checking the logs of this event to ensure that things are working and that backups will restore, you notice an output that is concerning.
The command the scheduled task is executing as follows:
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --protocol=TCP
> /backups/latest.sql
Warning: Using a password on the command-line interface can be insecure.
Which two methods are available to avoid the warning? (Choose two.)

A. Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.

B. Store your password in an option file eg: ~/.my.cnf and use --defaults-file so that it is read and used.
[client]
password=t100043va

C. Connect through the --socket rather than the default --protocol=TCP for local connection.
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --socket=/tmp/mysql.sock > /backups/ latest.sql

D. Use the password validation plugin available to improve user name and password strength.

正解: A,D

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

質問 9

You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

A. -old-passwords, to start MySQL to use the old password format while running without the grant tables.

B. -read-only, to set all data to read-only except for super users

C. -skip-networking, to prohibit access from remote locations

D. -reset-grant-tables, to start the server with only the mysql database accessible.

正解: C

質問 10

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

A. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"

B. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

C. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

D. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

E. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

正解: C,D

質問 11

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

A. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

B. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

C. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'

D. using GRANT ... REQUIRE SSL for a secure connection

正解: C

質問 12

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

A. All users have unrestricted access.

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

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

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

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

正解: A,B

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

Oracle MySQL 5.7 Database Administrator - 1Z0-888 模擬練習