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

出題：1

While attempting to set up a new replication slave on host `192.168.0.25' with the user `replication', you encounter this error:

What should you do to resolve this error?

A. Add the user [email protected] with the correct password to the slave.

B. Add the user [email protected] with the correct password to the master.

C. Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

D. Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

正解：B 解答を投票する

出題：2

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

出題：3

You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?

A. include-log-file

B. master-data

C. include-master-info

D. master-binlog

正解：B 解答を投票する

出題：4

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

A. log-master-updates

B. rpl-recovery-rank

C. master-logging

D. enable-master-start

E. server-id

F. log_bin

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

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

出題：5

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

出題：6

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4.
Which backup method would you use to reload the corrupted InnoDB tables?

A. A text backup. A binary backup will still contain the corrupted segments.

B. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

C. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

D. A text backup. InnoDB does not allow you to make binary backups while the server is running.

正解：D 解答を投票する

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

出題：7

Consider a replication setup where a snapshot of the replication status shows:

Which statement is true?

A. The replication slave uses multisource replication with eight sources.

B. The last event received from the sydney channel was at 2018-05-08 14:55:01.

C. The melbourne channel is keeping up with the received events.

D. The melbourne channel is resolving a GTID conflict.

E. The sydney channel is keeping up with the received events.

正解：A 解答を投票する

出題：8

Consider the ANALYZE TABLE command.
In which two situations should this command be used?

A. when you want to check a tables structure to see if it may have been damaged and needs repair

B. when you want to update index distribution statistics

C. when you need to find out why a query is taking a long time to execute

D. after large amounts of table data have changed

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

出題：9

You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup? (Choose two.)

A.

B.

C.

D.

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

出題：10

Which two statements are true regarding MySQL security? (Choose two.)

A. The root or administrator users should own all files and directories to which the server writes.

B. The mysqld process owner should own all files and directories to which the server writes.

C. The mysqld process should not be run as root or administrator.

D. The mysqld process should be run as root or administrator.

E. The mysql user needs to have sudo privileges.

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

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