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

出題：1

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

出題：2

What three are correct statements about MySQL backups? (Choose three.)

A. They are used to set up a test system.

B. They are used to set up a replication slave.

C. They are used to prevent data theft.

D. They are used to recover data.

E. They are used to prevent data corruption.

F. They are used to set up the initial binary log files.

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

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

出題：3

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid for why one of the users is unable to connect to the database?

A. All users are blocked because max_user_connections is accumulated over the host account information.

B. Kay is already connected elsewhere and attempting to log in again.

C. Bob has max_user_connections set to zero, which blocks all his connections.

D. Joe has exceeded the max_user_connections global limit.

E. connect_timeout is too small to allow a connection to occur.

正解：D 解答を投票する

出題：4

Consider these global status variables:

Which two conclusions can be made from the output?

A. There are more connections being idle than executing queries.

B. There are 510 connections to MySQL at the time of the output.

C. The thread cache has been configured with thread_cache_size set to at least 6.

D. All max_connections were in use at 2018-03-22 14:54:06

E. There are 140 Performance Schema threads at the time of the output.

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

出題：5

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?

A. It provides means to help avoid accidentally exposing the MySQL login details.

B. A .mylogin.cnf file can store at most one login path.

C. It provides a FIPS-compliant keyring for storing MySQL login details.

D. mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

E. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

F. It is an alternative to storing the MySQL login details in a my.cnf file.

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

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

出題：6

Which two statements are true about InnoDB auto-increment locking?

A. InnoDB does not use locks to enforce auto-increment uniqueness.

B. InnoDB always protects auto-increment updates with a table-level lock

C. InnoDB never uses table_level locks.

D. Some settings for innodb_autoinc_lock_mode can help reduce locking.

E. The auto-increment lock can be a table-level lock.

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

出題：7

What two statements are true regarding FLUSH TABLES FOR EXPORT?

A. Table only exports when the table has its own tablespace.

B. The InnoDB Storage engine must be used for the table being exported.

C. It can be used to export TEMPORARY tables.

D. It is the safest way to extract tables from the shared tablespace.

E. Partitioned tables are not supported.

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

出題：8

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

出題：9

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

出題：10

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay- bin.00004', RELAY_LOG_POS = 1383;

B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

C. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

正解：B 解答を投票する

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