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

出題：1

Which two methods accurately monitor the size of your total database size over time?

A. monitoring the innodb_redo_log_size variable

B. monitoring cumulative Innodb_page_size increase

C. monitoring the performance_schema_hosts_size variable

D. monitoring the Innodb_rows_inserted status variable

E. monitoring datadir size in the operating system

F. monitoring the information_schemA.TABLES table

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

出題：2

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

出題：3

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

出題：4

You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

A. [mysql] and [mysqld]

B. [mysql] and [mysqladmin]

C. [mysqladmin]

D. [mysql]

E. [mysqld] and [mysqladmin]

F. [mysqld]

G. [mysql] and [mysqld] and [mysqladmin]

正解：D 解答を投票する

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

出題：5

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

出題：6

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

A. Configure IPv6 network for hosts.

B. Set isolation level to be SERIALIZABLE.

C. Guarantee a secondary index on every table.

D. Set multiple slave parallel worker threads.

E. Use the binary log row format.

F. Set isolation level to be READ COMMITTED.

G. Guarantee a primary key on every table.

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

出題：7

Exhibit:

What does the possible_keys column in this output denote?

A. whether there are any indexes in your query

B. whether there are any indexes on the tables that you are querying

C. if it is possible for you to include any indexes in your query

D. if there are any indexes that may be used to solve this query

正解：C 解答を投票する

出題：8

Consider:

Which statement best describes the meaning of the value for the key_len column?

A. It shows the total size of the index row.

B. It shows how many columns in the index are examined.

C. It shows how many bytes will be used from each index row.

D. It shows the number of characters indexed in the key.

正解：C 解答を投票する

出題：9

You enable binary logging on MySQL Server with the configuration:
binlog-format=STATEMENT
log-bin
Which database updates are logged on the master server to the binary log by default?

A. all updates except to the PERFORMANCE_SCHEMA database

B. all updates except to the TEMPDB database

C. all updates to the default database, except temporary tables

D. all updates to all databases

E. all updates not involving temporary tables

正解：C 解答を投票する

出題：10

Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

A. mysqladmin

B. mysqld_safe

C. mysqlpasswd

D. mysql_config_editor

正解：D 解答を投票する

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

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