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

出題：1

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

出題：2

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

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

出題：3

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 rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

B. 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.

C. 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"

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

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

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

出題：4

Which MySQL utility copies the master instance to a slave instance on the same host?

A. mysqldbcopy

B. mysqlserverclone

C. mysqlrplsync

D. mysqlfailover

正解：B 解答を投票する

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

出題：5

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

A. The server suspends operations for all storage engines until space becomes available.

B. An error message will be returned to the client .Server Error: ER_IO

C. The server suspends that INSERT operation until space becomes available.

D. The server will crash.

正解：C 解答を投票する

出題：6

Examine the mydata table and SELECT statements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

A. one row and a next-key lock for supremum

B. five

C. one row and a gap-lock

D. one

正解：B 解答を投票する

出題：7

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

A. They all connect via the secure sha256_password algorithm without any configuration change.

B. They will have to change their password the next time they login to the server.

C. They are not affected by this configuration change.

D. They will have their passwords updated on start-up to sha256_password format.

正解：C 解答を投票する

出題：8

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?

A. a file system-level snapshot

B. an up-to-date replication slave

C. a file system copy created while MySQL was shut down.

D. a backup created with mysqldump --all-databases

E. a backup created using FLUSH TABLES ... FOR EXPORT

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

出題：9

How does the InnoDB storage engine handle deadlocks when they are detected?

A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

B. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

C. Both the affected transactions will be rolled back.

D. One of the affected transactions will be rolled back, the other is allowed to proceed.

E. The transaction isolation level determines which transaction is rolled back.

正解：D 解答を投票する

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

出題：10

A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state. You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur?

A. The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

B. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

C. The applications have the SUPER privilege, which allows them to update rows.

D. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql

E. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

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

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