Q1041
Open questionWhich Keyword is used to remove duplicate rows in the result set?
Select an option to see the answer and solution.
MySQL · all questionsMySQL
MySQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
1,185
Questions
53/60
Page
Pick an option on a question to see the right answer and solution.
Q1042
Open questionWhat will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;Select an option to see the answer and solution.
Q1043
Open questionTo check if the data directory contains insecure files or directories, the command executed is . . . . . . . .
Select an option to see the answer and solution.
Q1044
Open questionWhich program is used as a utility for MyISAM table maintenance?
Select an option to see the answer and solution.
Q1045
Open questionThe MySQL server is not configurable.
Select an option to see the answer and solution.
Q1046
Open questionWhat 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 an option to see the answer and solution.
Q1047
Open questionabc in the following MySQL statement is . . . . . . . .
DELETE FROM xyz WHERE abc = 5;Select an option to see the answer and solution.
Q1048
Open question"MODIFY" is used with which "Query clause"?
Select an option to see the answer and solution.
Q1049
Open questionWhat is the generic handle whose meaning depends on context?
Select an option to see the answer and solution.
Q1050
Open questionIn 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;Select an option to see the answer and solution.
Q1051
Open questionThe datatype best suited to store currency values is . . . . . . . .
Select an option to see the answer and solution.
Q1052
Open questionWhat is the meaning of the "WHERE" clause in Mysql?
Select an option to see the answer and solution.
Q1053
Open questionIllegal values converted to the appropriate 'zero' value for . . . . . . . .
Select an option to see the answer and solution.
Q1054
Open questionWhat does the expression '12 DIV 5? evaluate to?
Select an option to see the answer and solution.
Q1055
Open questionThe function returning an array of row values is . . . . . . . .
Select an option to see the answer and solution.
Q1056
Open questionThe option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .
Select an option to see the answer and solution.
Q1057
Open questionIf emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id
FROM person
ORDER BY emp_id;Select an option to see the answer and solution.
Q1058
Open questionThe shebang line is . . . . . . . .
Select an option to see the answer and solution.
Q1059
Open questionWhich statement is used for updating existing information in the table?
Select an option to see the answer and solution.
Q1060
Open questionWhich type can store a collection of objects of any type?
Select an option to see the answer and solution.