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

質問 1

Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)

（A）MySQL becomes read-only except for setting passwords.

（B）All connections succeed regardless of the username and password.

（C）All users have unrestricted access.

（D）User authentication is based on the operating system username.

（E）Only the password for active account can be changed.

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

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

質問 2

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

（A）Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

（B）It results in a syntax error because you cannot specify more than one partition in the same statement.

（C）All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

（D）All data in p1 and p3 partitions is removed and the table definition is changed.

正解：C 解答を投票する

質問 3

Which three statements correctly describe MySQL InnoDB Cluster?

（A）The data is automatically shared between the nodes.

（B）It provides fully synchronous replication between the nodes.

（C）All MySQL client programs and connectors can be used for executing queries.

（D）Each query will be executed in parallel across the nodes.

（E）There is support for automatic failover when one node fails.

（F）The cluster can be operated in multimaster mode with conflict detection for DML statements.

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

質問 4

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

（A）They will have to change their password the next time they login to the server.

（B）They are not affected by this configuration change.

（C）They all connect via the secure sha256_password algorithm without any configuration change.

（D）They will have their passwords updated on start-up to sha256_password format.

正解：B 解答を投票する

質問 5

You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?

（A）the length of time before a newly created password expires

（B）whether a new password is rejected if it contains the current user's username.

（C）the amount of delay after an incorrect password is entered

（D）whether a new password is rejected if it contains a word found in a dictionary file.

正解：D 解答を投票する

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

質問 6

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

（A）when you want to update index distribution statistics

（B）after large amounts of table data have changed

（C）when you want to check a tables structure to see if it may have been damaged and needs repair

（D）when you need to find out why a query is taking a long time to execute

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

質問 7

Which statement best describes the purpose of the InnoDB buffer pool?

（A）It is amount of buffers available during a transaction.

（B）It caches data and indexes for InnoDB tables.

（C）It is a pool of memory for SQL query sort operations from within the InnoDB engine.

（D）It holds changes made during a transaction before they are written to the log.

（E）It caches only the indexes for InnoDB tables.

正解：B 解答を投票する

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

質問 8

Which three allocate memory per thread in MySQL?

（A）query cache

（B）internal temporary table

（C）InnoDB buffer pool instance

（D）read buffer

（E）sort buffer

（F）thread cache

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

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

質問 9

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

質問 10

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

（A）--skip-buffer

（B）--tab

（C）--quick

（D）--single-transaction

正解：C 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験