Oracle 1Z0-888 問題集

質問 1：
You enable binary logging on MySQL Server with the configuration:
binlog-format=STATEMENT
log-bin
Which database updates are logged on the master server to the binary log by default?
A. all updates except to the PERFORMANCE_SCHEMA database
B. all updates to the default database, except temporary tables
C. all updates to all databases
D. all updates not involving temporary tables
E. all updates except to the TEMPDB database
正解：B

質問 2：
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?
A. The server suspends operations for all storage engines until space becomes available.
B. The server will crash.
C. The server suspends that INSERT operation until space becomes available.
D. An error message will be returned to the client .Server Error: ER_IO
正解：C

質問 3：
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)
A. The query benefited from tmp_table_size increase.
B. Session variables are not persistent across server restarts.
C. Global variables are not persistent across server restarts.
D. The query benefited from sort_buffer_size and tmp_table_size increases.
E. The query benefited from sort_buffer_size increase.
F. sort_buffer_size should match tmp_table_size to be optimal.
正解：A,B,E

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

質問 5：
You are remotely logged in to MySQL as the user "backup".
The account has temporarily been granted full privileges WITH GRANTto perform the actions required.
You want to change the password for the locally existing "backup" user.
Select the three commands which will perform the required action. (Choose three.)
A. SET PASSWORD FOR `backup'@'localhost' = PASSWORD(`password')
B. ALTER USER `backup'@'localhost' IDENTIFIED BY `password';
C. CREATE USER `backup'@'localhost' IDENTIFIED BY `password';
D. ALTER USER `backup' IDENTIFIED BY `password';
E. SET PASSWORD = `password';
F. SET PASSWORD FOR `backup'@'localhost' = `password';
G. ALTER USER USER() IDENTIFIED BY `password';
正解：B,C,G