41. Which of the following options tells mysql to ask for entering the password?
42. Is "Datetime" and "Timestamp" are same data type?
43. The bit-field values are prefixed with . . . . . . . .
44. In UNIX, the name of the option file is . . . . . . . .
45. In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?
46. mysql_fetch_row() returns . . . . . . . .
47. How would a stored function named PI() written in the database 'sampdb' be called?
48. What column names are displayed when this SQL command is executed?
SHOW COLUMNS FROM tbl_name LIKE '%name';
SHOW COLUMNS FROM tbl_name LIKE '%name';49. What does 'A' stand for in the ACID property of transactions?
50. What is known as the set of SQL statements that either executes successfully or none of them have an effect?
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