1. (TCO 1) According to the book, a database system is essentially a high-powered way to manage _____. (Points : 4)

people numbers lists of information SQL

Question 2.2. (TCO 1) Which of the following is not a valid MySQL program used to communicate with the server? (Points : 4)

mysqladmin mysqlcheck mysqlroot mysqldump

Question 3.3. (TCO 2) To set up a MySQL account to use for connecting to the server it is necessary to connect to the server as the MySQL _____ user. (Points : 4)

admin root general DBA

Question 4.4. (TCO 2) Which of the following statements about how MySQL needs to be or can be installed is false? (Points : 4)

Because MySQL works on a network you do not need to be logged in on the server machine. Because MySQL works on a network you need to be logged in on the server machine. Because MySQL works on a network you only need to be able to connect a client to the server. Because MySQL works on a network you have to have Internet access regardless.

Question 5.5. (TCO 3) Which one of the following scripts is run to initialize the data directory during a MySQL install on a Unix system? (Points : 4)

mysql_install_db mysql_install_dd mysql_install_dir mysql_install

Question 6.6. (TCO 3) On a Windows server you have two options for starting MySQL. You can start it manually or you can _____. (Points : 4)

start it from a command line prompt start it from a browser window start it using a Window service for MySQL start it from a shortcut

Question 7.7. (TCO 3) The server maintains several system variables that are involved in various aspects of character set support. Which one of the following is not a character set variable that indicates properties of the server or the current database? (Points : 4)

character_set_system character_set_server character_set_client character_set_database

Question 8.8. (TCO 3) Which of the following MySQL storage engines does not support spatial values? (Points : 4)

InnoDB MEMORY MyISAM ARCHIEVE

Question 9.9. (TCO 3) Which of the following MySQL storage engines offers the most flexibility for sequence handling? (Points : 4)

InnoDB MEMORY MyISAM ARCHIEVE

Question 10.10. (TCO 3) According to your textbook, which one of the following would not be considered a guideline for identifying columns to index? (Points : 4)

Columns that appear in the WHERE clause Columns that appear in the JOIN clause Columns that appear in the SELECT statement Columns that appear in the ORDER BY or GROUP BY

Question 11.11. (TCO 3) The data type used to define a column and the way it is defined can have a direct impact on how a query runs. Which of the following would not be considered a good practice based on information presented in your textbook? (Points : 4)

Using an enum or set data type for columns used in numeric operations when the columns have a limited number of values Using smaller data types like MEDIUMINT or FLOAT when appropriate Always allowing columns to have NULL values Using BLOB or TEXT columns to allow data to be packed

Question 12.12. (TCO 3) Which one of the following storage engines treat CHAR and VARCHAR columns the same in fixed-length rows making the choice in data type immaterial? (Points : 4)

InnoDB MyISAM MEMORY Federated

Question 13.13. (TCO 4) Which of the following is not an option for setting system variables? (Points : 4)

Setting at server startup Setting in an option file Setting before server startup Setting at runtime

Question 14.14. (TCO 4) The MySQL server provides a number of different storage engines to select from. Which of the storage engines listed below is not available by default? (Points : 4)

MyISAM MEMORY CSV FEDEERATED

Question 15.15. (TCO 4) To perform the initial setup of the system tablespace, which of the following steps would not be valid? (Points : 4)

Add the appropriate lines to the options file Make sure that all of the component files already exist. Make sure that the directories exist for the tablespace component files. Start the server.

Question 16.16. (TCO 5) Which one of the following statements is not a valid statement to use in the creation or modification of a USER in MySQL? (Points : 4)

CREATE GRANT PROFILE REVOKE

Question 17.17. (TCO 5) When granting privileges to a user account, which key word defines the level at which the privileges apply? (Points : 4)

GRANT COLUMNS WHAT ACCOUNT

Question 18.18. (TCO 5) When granting privileges to a user account, which key word defines the account to which the privileges apply? (Points : 4)

GRANT COLUMNS WHAT ACCOUNT

Question 19.19. (TCO 5) Which of the following is not a valid level at which a privilege can be applied? (Points : 4)

Global Database Group Table

Question 20.20. (TCO 5) To enable an account to perform operation on stored routines the DBA would use the ALTER ROUTINE and EXECUTE privileges at which of the following levels? (Points : 4)

Global User Group Table