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

How to find all occurrences of text 'owner' in all fields of all tables in a MySQL, database?

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?

Examine the code: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?