Q1001
Open questionThe statement that makes changes to the global attributes of the database is . . . . . . . .
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
51/60
Page
Pick an option on a question to see the right answer and solution.
Q1002
Open questionWhich operator is used to check whether the expression is "NULL"?
Select an option to see the answer and solution.
Q1003
Open questionWhat is the synonym for REAL?
Select an option to see the answer and solution.
Q1004
Open questionWhat will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;Select an option to see the answer and solution.
Q1005
Open questionThe logging option to enable binary log index file is . . . . . . . .
Select an option to see the answer and solution.
Q1006
Open questionThe NULL value also means . . . . . . . .
Select an option to see the answer and solution.
Q1007
Open questionWhat is the number of attributes in the following SQL table?
CREATE TABLE employee (
emp_name CHAR(30),
emp_id INT
);Select an option to see the answer and solution.
Q1008
Open questionWhich statement can produce the same output as 'SHOW COLUMNS'?
Select an option to see the answer and solution.
Q1009
Open questionWhat is the option for specifying the executable name while compiling with gcc?
Select an option to see the answer and solution.
Q1010
Open questionIn the CREATE TABLE statement, the engine name specified is case sensitive.
Select an option to see the answer and solution.
Q1011
Open questionWhat will be the output of the following MySQL command?
SELECT *
FROM person
WHERE emp_id IS NULL;Select an option to see the answer and solution.
Q1012
Open questionWhich feature is used for the automatic increment of the column?
Select an option to see the answer and solution.
Q1013
Open questionIn Boolean search, results are sorted by relevance.
Select an option to see the answer and solution.
Q1014
Open questionThe statement that constructs a branching flow-control construct is . . . . . . . .
Select an option to see the answer and solution.
Q1015
Open questionFor which of these is the startup option best suited?
Select an option to see the answer and solution.
Q1016
Open questionWhich of the following operators is/are used in "Condition Evaluation"?
Select an option to see the answer and solution.
Q1017
Open questionWhich of these is not an exact numeric type?
Select an option to see the answer and solution.
Q1018
Open questionThe keyword used to create a database is . . . . . . . .
Select an option to see the answer and solution.
Q1019
Open questionWhich of these comparisons is slowest?
Select an option to see the answer and solution.
Q1020
Open questionAmong the following, for which language is image processing least simple?
Select an option to see the answer and solution.