MYSQL 1Z0-874 問題集

質問 1：
Which of the following are true regarding the usage of the IDENTIFIED BY clause in the GRANT statement used to create a new user account? (Choose two)
A. The IDENTIFIED BY clause specifies the password to be used with the account
B. The IDENTIFIED BY clause is always mandatory
C. There is no IDENTIFIED BY clause for the GRANT statement
D. The IDENTIFIED BY clause specifies an alternate user name for the account
E. The IDENTIFIED BY clause is always optional
F. The IDENTIFIED BY clause may be mandatory depending on the current SQL mode
正解：A,F

質問 2：
Which of the following statements about the slow query log is true?
A. The slow query log always logs more than just slow queries.
B. The slow query log will always contain just slow queries.
C. The slow query log may not always contain just slow queries.
正解：C

質問 3：
Which of the following statements are true of how access control is based?
A. It is based off of an access control list stored inside the .frm files of each table.
B. It is based off of an access control table in the mysql database.
C. It is based off of grant tables in the mysql database.
D. it is based off of an access control list stored in the data directory.
正解：C

質問 4：
Is it ever safe to start the MySQL server as root?
A. Yes it is always safe to start it as root.
B. No it is never safe to start it as root.
C. Yes provided you make it switch the effective user to mysql.
D. No because you can not make it switch the effective user if started as root.
正解：C

質問 5：
Consider the following:
mysql> EXPLAIN SELECT Name FROM City WHERE CountryCode = (SELECT Code FROM
Country
WHERE Name = 'United States')
*************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: City
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 4079
Extra: Using where
Which of the following best describes the meaning of the value of the select_type column?
A. The query has a subquery.
B. The inner select is the SELECT referred to in the output row.
C. It is the first SELECT in a subquery.
D. The outer select is the SELECT referred to in the output row.
正解：D

質問 6：
Which of the following best describes the relationship between MAX_ROWS, AVG_ROW_LENGTH and the max table size?
A. MAX_ROWS * AVG_ROW_LENGTH tells MySQL how large you expect the table to grow to.
B. MAX_ROWS + AVG_ROW_LENGTH tells MySQL to not let the table grow past that size.
C. Specifying MAX_ROWS and AVG_ROW_LENGTH doesn't prevent MySQL from growing the table beyond that limit.
D. Specifying MAX_ROWS and AVG_ROW_LENGTH will prevent MySQL from growing the table beyond that limit.
正解：C

質問 7：
What type of resource limitations may be placed on a user account with the GRANT statement? (Choose four)
A. The number of updates per hour an account is allowed to issue
B. Resource limits can only be specified globally, not per-account
C. The maximum number of simultaneous connections an account can have
D. The number of queries per hour an account is allowed to issue
E. The number of times per hour that an account is allowed to connect to the server
F. MySQL does not have provisions for limiting resource usage
正解：A,C,D,E

質問 8：
By default, mysqld's memory settings are...
A. Set to a median value good for overall general use.
B. There are no default memory settings for mysqld.
C. Rather conservative and should be increased if possible.
D. Rather consuming and should be decreased if possible.
正解：C

質問 9：
Which of the following are important network factors for remote MySQL clients? (Choose two)
A. Firewalls.
B. The type of routers used.
C. Latency.
D. Throughput speed.
正解：C,D