Oracle 1Z0-888 問題集

質問 1：
Which three allocate memory per thread in MySQL?
A. InnoDB buffer pool instance
B. read buffer
C. internal temporary table
D. sort buffer
E. query cache
F. thread cache
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

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

質問 3：
The account [email protected] has been created with privileges, as shown in the output:

The account [email protected] exists.
The account [email protected] does not exist.
Which three statements will succeed when executed by [email protected]? (Choose three.)
A. GRANT INSERT ON audit.* TO [email protected];
B. GRANT SELECT ON audit.* TO [email protected];
C. GRANT SELECT ON world.* TO [email protected];
D. GRANT SELECT ON world.* TO [email protected];
E. CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';
F. GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';
G. GRANT DELETE ON world.* TO [email protected];
正解：A,E,G

質問 4：
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)
A. to make sure that no table indexes are corrupted
B. to find out why a query takes a long time to execute on a given table
C. to improve performance by updating index distributing statistics on InnoDB tables
D. to repair table structure problem
E. to make sure a table has no structural problems
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Consider the key buffer in a MySQL server. Which two statements are true about this feature?
A. It caches index blocks for InnoDB tables only.
B. It is set on a per-connection basis.
C. It caches index blocks for all storage engine tables.
D. It is a global buffer.
E. It caches index blocks for MyISAM tables only.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)