61. Which mode prevents MySQL to perform full checking of date parts?
62. Which among the following data types can be used with "Range Condition"?
63. How many of the following is (are) considered as a special character by 'mysql_real_escape_string()'?
null byte, single quote, backslash
null byte, single quote, backslash
64. Which clause is used to sort a UNION result as a whole?
65. Which statement exits a labeled flow-control construct?
66. A view can be deleted using the command . . . . . . . .
67. The system variable 'system_time_zone' can be reset at runtime.
68. The mode of search is the search string parsed into words and the search looks for rows is . . . . . . . .
69. Does the following MySQL statement belong to the "Inequality 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’;
70. The ALL subquery performs operations on . . . . . . . .
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 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 12