What statement would delete the data in a table without deleting the table structure?

Difference between an inner join and an outer join?

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

With SQL you can manage files

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

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

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 query would NOT be used to administer a MySQL server?

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?

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

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