MYSQL 1Z0-874 問題集

質問 1：
The type of file system you chose may affect MySQL use and/or performance with regard to... (Choose three)
A. The number of users MySQL can handle.
B. Size limits of files.
C. Table opening time.
D. The type of storage engines that can be used.
E. Time to recover from a crash.
正解：B,C,E

質問 2：
Granting access to the mysql database...
A. Should never be done for any users.
B. Should be done for anyone needing to create views
C. Should always be done for all users.
D. Should only be done on administrator accounts.
正解：D

質問 3：
Which of the following is true of the table cache if you mainly run simple queries on many tables?
A. The table cache should be increased.
B. The table cache should not be changed.
C. The table cache should be decreased.
正解：A

質問 4：
The stored function year_to_date is created by the 'root'@'localhost' account as follows:
CREATE FUNCTION year_to_date ()
RETURNS DECIMAL(10,2)
SQL SECURITY DEFINER
BEGIN ... END;
Within the routine body, a number of calculations are made on data in the financials table and the calculated value is returned. The only account which can access the financials table is 'root'@'localhost'.
If a client connects with the account
'joe'@'localhost' and calls the year_to_date function, what will happen?
A. The function will always execute as if it was 'root'@'localhost' that invoked it since SQL SECURITY DEFINER has been specified.
B. The function will not execute, as 'joe'@'localhost' does not have access to the financials table
C. The function will not execute as SQL SECURITY DEFINER has been specified. It would execute if instead SQL SECURITY INVOKER had been specified
D. If the account 'joe'@'localhost' has the EXECUTE privilege on year_to_date, the function will complete successfully
正解：D

質問 5：
Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?
A. Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.
B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.
C. Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.
正解：B

質問 6：
When creating a new user account, which of the following are valid ways of specifying the hostname part of the account? (Choose six)
A. Using localhost
B. Using an IP number with wildcards, as 100.160.1.%
C. Leaving it unspecified, allowing connections from any host
D. Using a hostname, such as agric.comp1.com
E. Using a hostname pattern with wildcards, such as %.comp1.com
F. Using an IP address, such as 100.160.1.47
G. Using an IP number/netmask combination such as 100.160.0.0/255.255.0.0
H. User accounts do not contain a hostname part
正解：A,B,D,E,F,G

質問 7：
Which of the following best describes what MASTER_LOG_FILE and MASTER_LOG_POS provides? (Choose two)
A. The masters binary log name used for replication.
B. The file to log replication actions to.
C. The path of the log file.
D. The position in the masters binary log in which to start replication.
正解：A,D

質問 8：
Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it? (Choose two)
A. The operating system may be able to be reconfigured to increase this limit.
B. The --key_cache option may be used to increase the limit.
C. It is limited by the maximum size of the table cache.
D. The maximum number of threads per-process of the operating system.
正解：A,D

質問 9：
Which are the effects of the following statement mysql> SET GLOBAL query_cache_limit = 2097152;
A. The statement will generate an error because query_cache_limit can only be set for a single connection.
B. Query results up to 2MB will be cached in the Query Cache.
C. The total size of cached queries will be limited to 2MB.
D. Query results need to be at least 2MB in size to be cached in the Query Cache.
正解：B