If an error occurs, each of the numeric functions returns a/an ____________ value.

If there is no index, the dbms will perform a _____ scan.

When you have a subquery inside of the main query, which query is executed first?

You need to export the entire database, including the database objects, in addition to the data. Which command-line tool do you use?

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?

When joining tables using a left join, which values are always preserved?

TEXT is case-insensitive in BLOB.

Correct use of the UNION operator?

Which options for the INSERT statement will cause an existing row to be updated in the event of a duplicate Primary Key value?

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