Which of the following 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?

Maximum length of a table name ?

Which are true about MyISAM vs InnoDB?

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.

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

Databases are stored in ______ so that they are available when needed.