How can stored routines be used to check for constraints or legality of incoming data?
A. They can make use of the VALIDATE DEFINER setting.
B. They can not be used to check for constraints or legality of data.
C. They can check and only perform an action if the incoming values match a specified value.
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.
In replication the master server logs updates to this/these databases by default: A. No database.
B. The default database
C. The mysql database
D. All databases
E. All databases but mysql
Which of the following best describes the order in which MySQL considers host names and user names when a client attempts connection?
A. Hostnames then usernames
B. Usernames then hostnames
C. Both hostnames and usernames are checked concurrently.
Consider a stored procedure or function that is going to be executed. Which of the following statements are true?
A. First, the database level privileges are checked, then the global privileges, then the stored routine level privileges.
B. First, the global privileges are checked, then the stored routine level privileges, then the database level privileges.
C. First, the global privileges are checked, then the database level privileges, then the stored routine level privileges.
D. If the stored routine contains commands that access other databases and tables, access control for these objects will also be processed.
Is it possible to force the join order in a query, and if so how?
A. No, it is not possible.
B. Yes it is possible, use SELECT STRAIGHT_JOIN rather than just SELECT, the list the tables in the desired order.
C. Yes it is possible use SELECT FORCE_JOIN rather than just SELECT, then list the tables in the desired order.
D. Yes it is possible simply list the tables in the desired order in your SELECT.
Which of the following best describes when it might be advantageous to split a dynamic-row table into dynamic-row and fixed-row tables?
A. When the table contains both fixed and variable length columns, but the majority of queries on it access the fixed length columns.
B. When the table contains both fixed and variable length columns, but the majority of queries on it access the variable length columns.
C. When the table contains both fixed and variable length columns, and the majority of queries access both the variable and fixed length columns.
Which of the following optimizations could be made based on data collected in the slow query log?
A. Tune server parameters.
B. Change the storage engines in use.
C. Make changes to the network infrastructure.
D. Rewrite queries to perform more efficiently.
E. Normalize data or add indexes to the tables that the queries use.
The type of file system you chose may affect MySQL use and/or performance with regard to...
A. Table opening time.
B. Size limits of files.
C. Time to recover from a crash.
D. The number of users MySQL can handle.
E. The type of storage engines that can be used.
Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it?
A. It is limited by the maximum size of the table cache.
B. The --key_cache option may be used to increase the limit.
C. The maximum number of threads per-process of the operating system.
D. The operating system may be able to be reconfigured to increase this limit.
