31. Which of these returns a string containing an error message?
32. The 'mysqlbackup' command to perform a restore operation is . . . . . . . .
33. Consider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject NOT IN (c, c++, oop);
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject NOT IN (c, c++, oop);
34. Which is more efficient?
LOAD DATA, INSERT
LOAD DATA, INSERT
35. What is the meaning of "Inequality Condition"?
36. The maximum non zero value for FLOAT is . . . . . . . .
37. The file created by the server to store the database attributes is . . . . . . . .
38. What is xyz in the following MySQL statement?
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');
39. What is the join where all possible row combinations are produced?
40. What will be the result of the following MySQL command?
WHERE end_date IS NULL
AND (title=’teller’ OR start_date < ‘2007-01-01’)
WHERE end_date IS NULL
AND (title=’teller’ OR start_date < ‘2007-01-01’)
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 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12