21. If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in . . . . . . . .
22. Which keyword is used to specify the foreign key after the table is created?
23. Find the error in the following MySQL statement?
SELECT cust_id, fed_id
FROM customer
WHERE cust_id = ’I’
AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
SELECT cust_id, fed_id
FROM customer
WHERE cust_id = ’I’
AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;24. Hexadecimal numbers can be used in scientific notation.
25. How is a stored procedure invoked?
26. How many of the following do not support 'BIT' data type?
MyISAM, MEMORY, NDB
MyISAM, MEMORY, NDB27. Which command is used to remove existing tables or database?
28. Which clause is used to rename the existing table?
29. System variable in MySQL server that enables to configure the SQL mode is . . . . . . . .
30. If the scheduler is stopped, no events run.
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 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12