Oracle 1Z0-888 問題集

質問 1：
You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)
A. InnoDB Redo Log Size
B. Buffer Pool Size
C. Binary Log Size
D. Sort Buffer size
E. Key Buffer Size
F. Query Cache Size
正解：D,E

質問 2：
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 all connect via the secure sha256_password algorithm without any configuration change.
B. They are not affected by this configuration change.
C. They will have to change their password the next time they login to the server.
D. They will have their passwords updated on start-up to sha256_password format.
正解：B

質問 3：
You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup? (Choose two.)
A.

B.

C.

D.

正解：A,D

質問 4：
What are three typical causes of MySQL becoming suddenly slow and unavailable? (Choose three.)
A. A configuration change was made.
B. Monitoring has not enabled all Performance Schema instruments.
C. The MySQL Query Cache is disabled.
D. OPTIMIZE TABLE is not executed for the InnoDB tables.
E. The application executes a new untested query.
F. The hardware includes a single point of failure.
正解：B,C,D

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

質問 6：
Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index?
A. Add a generated column calculating YEAR(Birthday) and index that column.
B. Execute ANALYZE TABLE to update the index statistics.
C. Add a functional index for YEAR(Birthday).
D. Add FORCE INDEX (Birthday) to the query.
E. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
正解：D,E

質問 7：
You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)
A. ALTER USER bob PASSWORD = `secret_password';
B. REVOKE ALL PRIVILEGES FROM `'@'localhost';
C. ALTER USER `root'@'localhost' ACCOUNT LOCK;
D. ALTER USER bob@'%' IDENTIFIED BY `secret_password';
E. ALTER USER `'@'localhost' PASSWORD = `secret_password';
F. DROP USER `'@'localhost';
正解：A,D

質問 8：
Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
Which option is most likely to have a positive effect on the server's health and performance?
A. Reduce the size of redo logs to improve storage efficiency.
B. Increase the size of redo logs.
C. Lower innodb_max_dirty_pages_pct to flush more often.
D. Move redo logs to /dev/shm to improve their speed.
正解：C