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

出題：1

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

出題：2

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

A. apply-log

B. gtid_enable

C. binlog_format=STATEMENT

D. log-bin

E. bonlog_format=ROW

正解：D 解答を投票する

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

出題：3

A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

A. --master-data

B. --lock-all-tables

C. --skip-opt

D. --single-transaction

E. --create-apply-log

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

出題：4

What is the best method for monitoring Group Replication conflict resolution?

A. the PERFORMANCE_SCHEMA tables

B. the INNODB Lock Monitor details

C. the INFORMATION_SCHEMA tables

D. the SHOW STATUS command

E. the SHOW PROCESSLIST command

正解：A 解答を投票する

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

出題：5

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

A. setting --mysql_secure_configuration to enable paranoid mode

B. setting specific grant privileges to limit remote authentication

C. using SSL when transporting data over remote networks

D. setting --skip-networking when remote connections are not required

E. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications

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

出題：6

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

B. The sync_relay_log=1000 setting on the slave is too small.

C. sync_binlog=0 and the master server crashed.

D. binlog_format=STATEMENT and a non-deterministic query was executed.

E. binlog_cache_size=1024 is too small and transactions are lost.

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

出題：7

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

出題：8

You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?

A. InnoDB no longer automatically updates index statistics after 10% of the rows in a table change.

B. InnoDB no longer automatically updates index statistics after the table structure is altered.

C. InnoDB no longer automatically updates index statistics after an ANALYZE TABLE statement.

D. InnoDB no longer automatically updates index statistics after a CREATE TABLE statement.

正解：A 解答を投票する

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

出題：9

You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?

A. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.

B. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.

C. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.

D. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.

正解：B 解答を投票する

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

出題：10

Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
Which option is most likely to have a positive effect on the server's health and performance?

A. Lower innodb_max_dirty_pages_pct to flush more often.

B. Increase the size of redo logs.

C. Reduce the size of redo logs to improve storage efficiency.

D. Move redo logs to /dev/shm to improve their speed.

正解：A 解答を投票する

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