Oracle 1Z0-888 問題集

質問 1：
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

質問 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. All data in p1 and p3 partitions is removed and the table definition is changed.
C. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
D. It results in a syntax error because you cannot specify more than one partition in the same statement.
正解：C

質問 3：
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?
A. -old-passwords, to start MySQL to use the old password format while running without the grant tables.
B. -skip-networking, to prohibit access from remote locations
C. -reset-grant-tables, to start the server with only the mysql database accessible.
D. -read-only, to set all data to read-only except for super users
正解：B

質問 4：
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?
A. The host on the command line is not defined in the login path.
B. The .mylogin.cnf file is not readable.
C. The DNS is not configured correctly for slave1 host.
D. The mysqld instance has not been restarted after creating the login path.
E. There is no password defined in the login path.
正解：B

質問 5：
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?
A. a backup created using FLUSH TABLES ... FOR EXPORT
B. an up-to-date replication slave
C. a backup created with mysqldump --all-databases
D. a file system-level snapshot
E. a file system copy created while MySQL was shut down.
正解：C,D