81. The function returning reference to hash of row values is . . . . . . . .
82. mysql_store_result() does not return a result set.
83. In the following SQL command "*" stands for?
SELECT * FROM person;
SELECT * FROM person;
84. What is the meaning of "EMPTY SET" in the following MySQL command?
SELECT fname, lname, person_id
FROM person
WHERE lname=’s’;
/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
SELECT fname, lname, person_id
FROM person
WHERE lname=’s’;
/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
85. Which data and time datatype stores time value in 'hh:mm:ss' format?
86. Which status indicator assesses how effective the table cache is?
87. Which of the following is an illegal unquoted identifier name?
88. What will be the output of the following MySQL statement "false AND Null"?
89. "CREATE VIEW ..." command is used to create which type of table in Mysql?
90. What is the variable that is a handle to a database object?
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 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 11
- MySQL Miscellaneous - Section 12