Which datatype is used to store binary data in MySQL?

Which statements relating to Alias names is true?

Which makes a backup on the whole database except the tables sessions and log?

Correct way to show that last queries executed on MySQL?

Which represents a valid use of COUNT() in a WHERE clause?

Which will reclaim unused space in all databases of a MySQL server instance?

Most common use of the mysql EXPLAIN statement?

Correct way to change the character set to UTF8?

When running the SELECT query: SELECT ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) ); The error message 'Every derived table must have its own alias' appears. Which of the following is the best solution for this error?

Which function is used to get the higher of two values, a and b, in MySQL?

Suppose a table has the following records: +--------------+-------------+----------------+ | Item | Price | Brand | +--------------+-------------+----------------+ | Watch | 100 | abc | | Watch | 200 | xyz | | Glasses | 300 | bcd | | Watch | 500 | def | | Glasses | 600 | fgh | +--------------+-------------+----------------+ Which of the following will select the highest-priced record per item?