21. Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?
22. What is the need of "column Aliases" in "SELECT" clause?
23. In the following MySQL command how many rows will be deleted?
DELETE person
WHERE person_id<10;
/*person_id is a primary key */
DELETE person
WHERE person_id<10;
/*person_id is a primary key */
24. The following MySQL statement belongs to which condition types?
SELECT fname
FROM person
WHERE fed_id=’111-11-111’;
SELECT fname
FROM person
WHERE fed_id=’111-11-111’;
25. The function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .
26. Which variable is used to set table alias names as non-case sensitive?
27. Which keyword is used to search through natural language fulltext?
28. What is 'xyz' in the following SQL statement?
SELECT xyz FROM table1 UNION xyz FROM table2;
SELECT xyz FROM table1 UNION xyz FROM table2;
29. The function that returns a reference to an array of row values is . . . . . . . .
30. The statement used to remove indexes on tables 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 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