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

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

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

Correct use of the UNION operator?

TEXT is case-insensitive in BLOB.

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

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

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?

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

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

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