Oracle 1Z0-888 問題集

質問 1：
Which three statements correctly describe MySQL InnoDB Cluster?
A. Each query will be executed in parallel across the nodes.
B. There is support for automatic failover when one node fails.
C. All MySQL client programs and connectors can be used for executing queries.
D. It provides fully synchronous replication between the nodes.
E. The cluster can be operated in multimaster mode with conflict detection for DML statements.
F. The data is automatically shared between the nodes.
正解：A,B,C

質問 2：
Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer?
A. The value should be increased from the default if the query joins large rows without using an index.
B. The value should be increased if the client performs several SELECT operations.
C. The join buffer is used to process sorts when complex joins are being performed.
D. The join buffer is global and can be changed only by restarting the server.
E. The join buffer is set per connection.
正解：A,C

質問 3：
What does the Performance Schema provide?
A. insight into the internal working of MySQL
B. a text-based version of MySQL Enterprise Monitor
C. recommendations for schema changes
D. auto-tuning based on settings and ongoing workload
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?
A. Change the table to use HASH indexes instead of BTREE indexes.
B. Set the value of innodb_adaptive_hash_index to zero.
C. Increase the value of the innodb_read_io_threads option.
D. Deactivate the query cache.
E. Increase the size of the InnoDB buffer pool.
F. Increase the value of the innodb_lock_wait_timeout option.
正解：C,E

質問 5：
You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?
A. mysql -u root -p < support-files/mysqldb.sql
B. mysqld_safe --user=mysql
C. mysqld --initialize ...
D. mysqld_safe --initialize ...
E. service mysqld prepare-init
正解：C
解説: (Topexam メンバーにのみ表示されます)