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

質問 1

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] and [mysqladmin]

（B）[mysqld] and [mysqladmin]

（C）[mysql] and [mysqld]

（D）[mysqladmin]

（E）[mysqld]

（F）[mysql]

（G）[mysql] and [mysqladmin]

正解：F 解答を投票する

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

質問 2

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

（A）The max_connections variable on the slave needs to be increased.

（B）The log_bin variable is set to OFF on the slave.

（C）The version of the slave is newer that the version of the master.

（D）The shared_memory_base_name variable must match the master.

（E）server_id is not unique.

正解：B 解答を投票する

質問 3

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

（A）The query did not find its table in the table definition cache.

（B）The event with event_id = 8945 is a child of the event with event_id=8944.

（C）The query read data from the data file rather than directly from the buffer pool.

（D）The time the query took is the sum of all timer_wait values.

正解：A 解答を投票する

質問 4

Which statement is true about tablespaces?

（A）General tablespaces can be configured to span multiple files.

（B）The system tablespace can be configured to span multiple files.

（C）All tables must be in either the system tablespace or a general tablespace.

（D）All tablespace files must be in the directory specified by the -datadir option.

正解：C 解答を投票する

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

質問 5

Which two methods will provide the total number of partitions on a table? (Choose two.)

（A）Query the performance_schema.objects_summary_global_by_type table

（B）Query the INFORMATION_SCHEMA.TABLES table for the partition_count

（C）Use the command: SHOW CREATE TABLE

（D）Query the INFORMATION_SCHEMA.PARTITIONS table

（E）Use the command: SHOW TABLE STATUS

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

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

質問 6

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

（A）binlog_format=STATEMENT and a non-deterministic query was executed.

（B）The sync_relay_log=1000 setting on the slave is too small.

（C）sync_binlog=0 and the master server crashed.

（D）enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

（E）binlog_cache_size=1024 is too small and transactions are lost.

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

質問 7

Which three tasks are handled by the optimizer?

（A）Decide which indexes to use.

（B）Validate the query.

（C）Parse the query.

（D）Execute the query.

（E）Verify that the user is allowed to execute the query.

（F）Change the order in which the tables are joined.

（G）Rewrite the WHERE clause.

正解：C、D、G 解答を投票する

質問 8

You have issued this statement:
GRANT PROXY ON 'a' FOR 'b';
When user account 'b' issues a query, the query returns an access denied error.
What could have caused that error?

（A）When connecting, user account 'b' is not entering the correct password for user account 'a'.

（B）User account 'b' has not been granted permission to access the data being queried.

（C）User account 'a' has not been granted permission to access the data being queried.

（D）You have not set the proxy_user variable in the configuration file.

正解：A 解答を投票する

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

質問 9

After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

（A）The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.

（B）The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

（C）The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.

（D）The mysql service has already been started on the same port.

（E）You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
80, which is in use by the built-in web server.

正解：B 解答を投票する

質問 10

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
Which statement is true?

（A）This prevents mysqld from starting when standard startup scripts are used.

（B）The OS needs to allow logging in as mysql so that administrative tasks can be performed.

（C）The mysql user needs a login and its home directory must be the base directory of the installation.

（D）This prevents creation of a command shell with the mysql account, while allowing mysqld to run.

正解：C 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験