1. (TCO 1) According to your text, the collection of data in a database is organized into _____. (Points : 10)

tables files logs records

Question 2.2. (TCO 1) According to your text, in the event of a crash which of the following is of crucial importance? (Points : 10)

Backups Log files data files Backup power source

Question 3.3. (TCO 3) According to your text, which of the following would be the first administrative task that you perform after installing the MySQL database? (Points : 10)

Log in and make sure you can log back on. Ensure that the server can be accessed only by authorized users. Create the data dictionary. Run a query to see what tables were installed.

Question 4.4. (TCO 3) Which of the following is stated in your textbook as being a way that MySQL handles out-of-range or otherwise improper values numeric or time data type columns in a table? (Points : 10)

Data that is too long is truncated to fit the maximum length of the column. Values outside the legal range are clipped to the nearest endpoint of the range and the resulting value is stored. It depends on the values that are listed as legal in the column definition. An error is raised and the value is not allowed.

Question 5.5. (TCO 4) Which of the following commands will by default only show session variable values? (Points : 10)

SHOW GLOBAL VARIALBES SHOW VARIABLES SHOW SESSION VARIABLES SHOW LOCAL VARIABLES

Question 6.6. (TCO 5) Database owners usually, and rightly, consider database contents to be _____. (Points : 10)

public private shared personal

Question 7.7. (TCO 5) The auth_info clause in the CREATE USER statement serves what purpose? (Points : 10)

Which host is authenticated How the server is authenticated at login How the account is authenticated at login How the database is authenticated at login

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

GRANT COLUMNS WHAT ACCOUNT

Question 9.9. (TCO 5) Which of the following user privileges is not considered an object privilege? (Points : 10)

ALTER RELOAD FILE GRANT OPTION

Question 10.10. (TCO 5) In order for a user to be able to grant its own privileges to another user the original user must have which of the following privileges? (Points : 10)

GRANT ALTER GRANT OPTION SUPER