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

質問 1

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

（A）Sort Buffer size

（B）Buffer Pool Size

（C）Query Cache Size

（D）Binary Log Size

（E）Key Buffer Size

（F）InnoDB Redo Log Size

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

質問 2

You want to dump only data from the userdata table.
Which mysqldump command argument is required to accomplish this?

（A）--single-transaction as this obtains a consistent view of data only

（B）--table=userdata in order to dump only the data from the userdata table

（C）--no-create-info to skip writing CREATE TABLE statements

（D）--data-only as this specifies that only data is to be dumped

正解：A 解答を投票する

質問 3

Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

（A）ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);

（B）ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);

（C）ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);

（D）ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);

正解：B 解答を投票する

質問 4

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

（A）It relies on the shared disk architecture being visible to both servers.

（B）It implements High Availability by using the NET Connector's load balancing capabilities.

（C）It is a shared-nothing architecture.

（D）It is provided by means of IP-level disk replication.

正解：A 解答を投票する

質問 5

Consider:

What does the range value in the type column mean?

（A）This type of index uses the range hash.

（B）The table will be scanned over a certain range of values.

（C）You can use an index and return rows that fall within a range of values.

（D）There is a range of indexes that can be used.

正解：A 解答を投票する

質問 6

To query two system variables, you execute this statement and get the results shown:

When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?

（A）max_connections must be set globally instead of locally.

（B）max_connections is a read-only variable that cannot be set dynamically.

（C）max_connections must be set at server start in an options file.

（D）max_connections is a derived variable that can only be set indirectly.

正解：C 解答を投票する

質問 7

Exhibit:

What does the possible_keys column in this output denote?

（A）if there are any indexes that may be used to solve this 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）whether there are any indexes in your query

正解：C 解答を投票する

質問 8

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

（A）The slave is configured with slave_parallel_workers = 4

（B）The salve has two intermediate relay slaves connected to it.

（C）THREAD_ID 21 has stopped running.

（D）The server needs more cores to use all slave threads.

（E）At most, two schemas are being updates concurrently.

（F）The slave cannot process the relay log fast enough to use all threads.

正解：A、F 解答を投票する

質問 9

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

（A）The engine type is not appropriate to the application use.

（B）No indexes are defined.

（C）Using default values for DATETIME causes table scans.

（D）The User field is too long for most names.

（E）Date should be a TIMESTAMP field for better performance.

正解：A、B 解答を投票する

質問 10

The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

（A）All these tables have the same number of rows.

（B）The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.

（C）The session_statustable is equivalent to status_by_threadfor the current thread.

（D）The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.

（E）The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.

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

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

弊社を連絡する

関連リンク

トップ試験