1.
Is there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY 2, 5;

2.
The function that returns reference to hash of row values is . . . . . . . .

3.
Which datatype is used for a fixed length binary string?

4.
Post MySQL 6.0, utf8 was . . . . . . . .

5.
Is the following MySQL statement belongs to the "Equality condition"?
SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name=’customers_accounts’;

6.
What will be the result of the following MySQL command?
WHERE TITLE= ‘teller’ AND start_date < ’2007-01-01’

7.
Which of the following WHERE clauses are faster?
1. WHERE col * 3 < 9
2. WHERE col < 9 / 3

8.
What allows nesting one select statement into another?

9.
What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’F’;

10.
Which function returns an array of row values?