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

出題：1

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

A. using GRANT ... REQUIRE SSL for a secure connection

B. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

C. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'

D. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

正解：C 解答を投票する

出題：2

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

出題：3

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

A. executing REVOKE FILE FROM *_*

B. setting the --local-infile=0 option when starting mysqld

C. setting the --local-service=0 option when starting mysqld

D. setting the --open-files-limit=0 option when starting mysqld

E. executing REVOKE FILE ON *_* FROM ` `@'%'

F. executing REVOKE LOAD FROM *.*

正解：D 解答を投票する

出題：4

Which two options describe how MySQL Server allocates memory?

A. Each thread allocates memory from a global pool.

B. Each connection may have its own per-thread memory allocations.

C. Global memory resources are allocated at server startup.

D. Thread memory is pre-allocated up to thread_cache_size for performance.

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

出題：5

You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_namein the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cacheevent is dominating other wait events.
* The Table_open_cache_overflowsstatus variable is 0.
Which action should be taken to remove the performance bottleneck described here?

A. Decrease the value of table_definition_cache.

B. Increase the value of table_open_cache_instances.

C. Increase the value of table_definition_cache.

D. Increase the value of table_open_cache.

E. Decrease the value of table_open_cache.

F. Decrease the value of table_open_cache instances.

正解：B 解答を投票する

出題：6

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

出題：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

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 are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?

A.