MYSQL 1Z0-874 問題集

質問 1：
Which of the following optimizations could be made based on data collected in the slow query log? (Choose four)
A. Change the storage engines in use.
B. Tune server parameters.
C. Rewrite queries to perform more efficiently.
D. Make changes to the network infrastructure.
E. Normalize data or add indexes to the tables that the queries use.
正解：A,B,C,E

質問 2：
Which of the following describe the correct single-statement syntax for allowing the existing user 'kofi'@'%' to perform SELECT, INSERT, DELETE and UPDATE actions on all tables in the world database?
A. GRANT world.* (SELECT, INSERT, DELETE, UPDATE) TO 'kofi'@'%'
B. Unless using ALL PRIVILEGES, it is not possible to assign more than one type of privilege at any one time.
C. GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%';
D. GRANT (SELECT, INSERT, DELETE, UPDATE) ON world.* TO 'kofi'@'%'
E. GRANT SELECT INSERT DELETE UPDATE ON world.* TO 'kofi'@'%'
正解：C

質問 3：
Does max_connections have an affect on the number of slaves that may connect to a master?
A. Yes, because each slave is effectively a connected user.
B. No, because slaves are not really clients.
C. Yes, because if the server has too many connections, it may slow the slaves down.
D. No, because slaves do not use the same type of connection as a regular client.
正解：A

質問 4：
Consider the following:
+----+-----------------+--------------+
| id | PartName | Location |
+----+-----------------+--------------+
| 1 | 40GB Hard Drive | Jacksonville |
| 2 | 1GB DDR | Atlanta |
| 3 | Keyboard | San Jose |
| 4 | Monitor | Harrisburg |
| 5 | USB Drive | Miami |
| 6 | DVD/R | Jacksonville |
+----+-----------------+--------------+
Which of the following best describes why this table should be split into a part and location table?
A. Because it has multiple repeating groups in each row.
B. This table should not be split as it is already in third normal form.
C. Because it has redundant location values.
正解：C

質問 5：
As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement: GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' Which of the following best describe the effects of issuing this statement?
A. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.
B. Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.
C. There is not enough information provided to determine the outcome of executing that statement.
D. Since no password is specified, the account is created with an empty password that must be changed by the user on first login
E. The account is not created, as you must always specify a password for new users
正解：B

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

質問 7：
In regards to security, which of the following statements are true? (Choose two)
A. The user owning the server process should own all files and directories to which the server may write.
B. Mysqld should be run as root or administrator.
C. The root or admininistrator users should own all files related to the server process
D. Mysqld should not be run as root or administrator.
正解：A,D

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

質問 9：
Which of the following best describes how the relay log works?
A. When a slave receives a change from the master, it is recorded in the relay log first and processed later.
B. When a slave receives a change from the master, it is processed first and then recorded in the relay log.
C. It records the times when the slave connects to the master.
正解：A