Oracle 1Z0-888 問題集

質問 1：
Which statement is true about tablespaces?
A. All tablespace files must be in the directory specified by the -datadir option.
B. General tablespaces can be configured to span multiple files.
C. All tables must be in either the system tablespace or a general tablespace.
D. The system tablespace can be configured to span multiple files.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Consider these global status variables:

Which two conclusions can be made from the output?
A. The thread cache has been configured with thread_cache_size set to at least 6.
B. All max_connections were in use at 2018-03-22 14:54:06
C. There are more connections being idle than executing queries.
D. There are 140 Performance Schema threads at the time of the output.
E. There are 510 connections to MySQL at the time of the output.
正解：C,E

質問 3：
You want to immediately stop access to a database server for remote user
'mike'@'client.example.com'. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user? (Choose two.)
A. Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;
B. Execute the mysql_secure_installation command.
C. Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;
D. Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';
E. Use DROP USER `mike'@'client.example.com';
F. Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;
正解：A,E

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

質問 5：
Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?
A. mysqldump
B. mysqldumpslow
C. mysqlslow
D. mysqlaccess
E. mysqlshow
正解：B