Oracle 1Z0-888 問題集

質問 1：
You created a backup of the world database with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql?
A. mysql>USE test; mysql>SOURCE dump.sql;
B. shell> mysqladmin recover test dump.sql
C. mysql> USE test; mysql> LOAD DATA INFILE `dump.sql';
D. shell> mysqlimport test dump.sql
E. shell> mysql test < dump.sql
正解：C,D

質問 2：
While attempting to set up a new replication slave on host `192.168.0.25' with the user `replication', you encounter this error:

What should you do to resolve this error?
A. Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.
B. Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.
C. Add the user [email protected] with the correct password to the slave.
D. Add the user [email protected] with the correct password to the master.
正解：D

質問 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：
You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
"permissive".
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?
A. 3302
B. 3304
C. 3301
D. 3303
正解：C

質問 5：
You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?
A. InnoDB no longer automatically updates index statistics after the table structure is altered.
B. InnoDB no longer automatically updates index statistics after 10% of the rows in a table change.
C. InnoDB no longer automatically updates index statistics after an ANALYZE TABLE statement.
D. InnoDB no longer automatically updates index statistics after a CREATE TABLE statement.
正解：B
解説: (Topexam メンバーにのみ表示されます)