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

出題：1

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

出題：2

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

出題：3

Consider:

Which statement best describes the meaning of the values in the ref columns?

A. world.City.CountryCode is used to sort the rows in the Citytable.

B. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.

C. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

D. world.City.CountryCodeis used as the primary key for the Country table.

正解：C 解答を投票する

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

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

出題：6

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

A. it contains a general tablespace.

B. it contains the undo log.

C. it contains the redo log.

D. it contains the system tablespace.

E. it is the default location for all new tables that you create.

F. it contains the binary log.

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

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

出題：7

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

出題：8

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

出題：9

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

出題：10

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

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