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;
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’;
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’
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
1. WHERE col * 3 < 9
2. WHERE col < 9 / 38. 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’;
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’F’;10. Which function returns an array of row values?
Read More Section(MySQL Miscellaneous)
Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.
- MySQL Miscellaneous - Section 1
- MySQL Miscellaneous - Section 2
- MySQL Miscellaneous - Section 3
- MySQL Miscellaneous - Section 4
- MySQL Miscellaneous - Section 5
- MySQL Miscellaneous - Section 6
- MySQL Miscellaneous - Section 7
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12