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 SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%';
B. GRANT SELECT INSERT DELETE UPDATE ON world.* TO 'kofi'@'%'
C. GRANT world.* (SELECT, INSERT, DELETE, UPDATE) TO 'kofi'@'%'
D. GRANT (SELECT, INSERT, DELETE, UPDATE) ON world.* TO 'kofi'@'%'/TT>
E. Unless using ALL PRIVILEGES, it is not possible to assign more than one type of privilege at any one time.
You have two databases, db1 and db2 and you have a table test in both of the databases. Your current
default database is db1.
Which of the following tables will be affected by the following command?
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test TO 'joe'@'%' IDENTIFIED BY 'sakila'
A. db1.test
B. db2.test
C. Both db1.test and db2.test
D. The statement will return an error, because no database was specified.
When working with replication, why might you want to stop the SQL thread on the slave while keeping the I/O thread running?
A. So that no changes are made while making backups.
B. So that events for the slave do not get backlogged on the master.
C. So that remaining events can be processed while not receiving new events from the master.
Why should you be selective when granting the PROCESS privilege to an account?
A. Because it allows the client to control running processes on the server.
B. Because it allows the client to process scripts.
C. Because it allows for the use of the SHOW PROCESSLIST command, which can expose data.
D. Because it allows for the use of stored routines.
Which of the following is/are valid reasons to consider using --skip-networking?
A. Your server is not networked to other servers.
B. You do not have a need for remote clients to connect.
C. You have a need for remote clients to connect.
D. You are not going to use replication or clustering.
Which of the following would be considered a good candidate table for compression?
A. A table with data that needs only few updates in the future.
B. A table with data that will not be updated in the future.
C. A large table, such as those used for data warehousing.
D. All MyISAM tables are good candidates for compression.
Which of the following statements about MEMORY tables are true?
A. Creating many MEMORY tables should be avoided.
B. It is OK to store large amounts of data in MEMORY tables.
C. MEMORY tables should not be used to store large amounts of data.
D. The number of MEMORY tables on a server will not cause any performance problems.
Which of the following best describes the purpose of the join buffer, and when should you increase the size of it?
A. The join buffer is used to process joins.
B. The join buffer is set per-connection.
C. The join buffer is global and can only be changed by restarting the server.
D. The value should be increased if the client performs a lot of SELECT operations.
E. The join buffer is used to process sorts when complex joins are being performed.
F. The value should be increased if the client has the tendency to perform complex joins.
When performing diagnostic functions on a server should excessive start and stop messages be looked for in the error log, and why?
A. No, start and stop messages are of no relevance to diagnostics.
B. Yes, because there is a bug in mysqld that can cause multiple start and stop messages to be inserted in the log.
C. No, because they will not provide any information as to what is wrong.
D. Yes, because they can indicate that there is something causing the server to restart unexpectedly and not due to normal startup and shutdown.
Can you have several MySQL servers running on the same computer, using the same InnoDB tablespace files?
A. No
B. Yes, always
C. Yes, provided their permissions are set to read-only