41. Which Keyword is used to remove duplicate rows in the result set?
42. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;
SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;
43. To check if the data directory contains insecure files or directories, the command executed is . . . . . . . .
44. Which program is used as a utility for MyISAM table maintenance?
45. The MySQL server is not configurable.
46. What will be the result of the following MySQL command?
SELECT emp_id,
‘ACTIVE’ AS STATUS,
emp_id * 3.14 AS emp_pi,
UPPER (lname) AS last_name
FROM employee;
SELECT emp_id,
‘ACTIVE’ AS STATUS,
emp_id * 3.14 AS emp_pi,
UPPER (lname) AS last_name
FROM employee;
47. abc in the following MySQL statement is . . . . . . . .
DELETE FROM xyz WHERE abc = 5;
DELETE FROM xyz WHERE abc = 5;
48. "MODIFY" is used with which "Query clause"?
49. What is the generic handle whose meaning depends on context?
50. In the following MySQL query, "person_1" belongs to which category of table in MySQL?
CREATE VIEW person_1 AS
SELECT fname, lname, person_id FROM person;
CREATE VIEW person_1 AS
SELECT fname, lname, person_id FROM person;
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 10
- MySQL Miscellaneous - Section 12