61. Is the following statement is true/false?
"An expression can be NULL, but can never equal to NULL"
"An expression can be NULL, but can never equal to NULL"
62. Which command is used to create "Temporary tables" in MySQL?
63. Which procedure parameter enables the caller to pass in a value and get back a value?
64. What is the significance of the statement "HAVING COUNT (emp_id)>2" in the following MySQL statement?
SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
HAVING COUNT (emp_id)>2
SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
HAVING COUNT (emp_id)>2
65. The option necessary to compile a C program havin math functions is . . . . . . . .
66. The mode that does not remove trailing spaces when CHAR values are retrieved is . . . . . . . .
67. PHP scripts are located in the web server document tree.
68. Which of the following statements is/are correct?
69. In which directory are the DBI scripts located?
70. The clause that is used to display information that matches a given pattern is . . . . . . . .
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 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12