Which of the following will restore a MySQL DB from a .dump file?

Correct syntax to restore a database from command line?

Correct syntax to call a stored routine country_hos with a parameter of type VARCHAR is

Correct syntax to grant all privileges on all databases to a user?

Which command converts Unix Timestamp to Mysql Timestamp and vice versa?

Syntax to list all databases in mysql?

Transactions and commit/rollback are supported by MySQL using the MyISAM engine

ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock colum

Which one correctly selects rows from the table myTable that have NULL in column column1?

Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?

What will happen if some of the columns in a table are of char datatype and others are of varchar datatype?