21. The place where the server stores its databases and status files are the database directory.
22. The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is . . . . . . . .
23. What is the datatype for single precision floating point number?
24. The option that suppresses output unless there are errors in the table is . . . . . . . .
25. What does the default case sensitivity of database and table names depend on?
26. Which variable is a handle to a database object?
27. How many of these are for use with only MyISAM tables?
mysql, mysqladmin, mysqldump, mysqlisamchk
mysql, mysqladmin, mysqldump, mysqlisamchk
28. Is there any error in executing the following MySQL command?
SELECT emp_id, ‘ACTIVE’,
emp_id * 3.145,
UPPER (lname)
FROM Employee;
SELECT emp_id, ‘ACTIVE’,
emp_id * 3.145,
UPPER (lname)
FROM Employee;
29. The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .
30. To produce a stored function, which statement is used?
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 11
- MySQL Miscellaneous - Section 12