You must ensure the accuracy and reliability of the data in your database. You assign some constraints to limit the type of data that can go into a table. What type of constraints are you assigning?

Which option of most MySQL command-line programs can be used to get a description of the program's different options?

MySQL uses environment variables in some of the programs and command-line operations. Which variable is used by the shell to find MySQL programs?

If you were building a table schema to store student grades as a letter (A, B, C, D, or F) which column type would be the best choice?

Which query would NOT be used to administer a MySQL server?

MySQL server can operate in different SQL modes, depending on the value of the sql_mode system variable. Which mode changes syntax and behavior to conform more closely to standard SQL?

Which correctly calls the stored procedure 'test' which has no parameters?

... application performs verification, repair, analysis, and optimization of MySQL databases, tables, and data.

With SQL you can manage files

Which option gets the current time in the following format? 2012-06-18 19:47:31

Difference between an inner join and an outer join?