Q681
Open questionWhat does CGI stand for?
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
35/60
Page
Pick an option on a question to see the right answer and solution.
Q682
Open questionThe log in which data changes received from a replication master server are written are . . . . . . . .
Select an option to see the answer and solution.
Q683
Open questionBy default, MySQL does not clip out of range numeric values to the nearest fit value.
Select an option to see the answer and solution.
Q684
Open questionIf in Table "employee", a column "emp_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?
SELECT DISTINICT emp_id
FROM employee;Select an option to see the answer and solution.
Q685
Open questionThe option in mysqlshow to show information about indexes in a table is . . . . . . . .
Select an option to see the answer and solution.
Q686
Open questionThe datatype for single precision floating point number is . . . . . . . .
Select an option to see the answer and solution.
Q687
Open questionWhat is the facility that allows nesting one select statement into another?
Select an option to see the answer and solution.
Q688
Open questionThe option for specifying the executable name while compiling with gcc is . . . . . . . .
Select an option to see the answer and solution.
Q689
Open questionTo how many of these does the LOW_PRIORITY modifier apply to?
DELETE, INSERT, LOAD DATA, REPLACESelect an option to see the answer and solution.
Q690
Open questionWhich among the following operators is/are belongs to "Range conditions"?
Select an option to see the answer and solution.
Q691
Open questionWhat is the significance of "ORDER BY" in the following MySQL statement?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;Select an option to see the answer and solution.
Q692
Open questionA procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.
Select an option to see the answer and solution.
Q693
Open questionIn the following MySQL command how many rows will be updated?
UPDATE person
SET lname=’s’,
Fname = ’p’,
WHERE person_id = 1;
/* person_id is a primary key */Select an option to see the answer and solution.
Q694
Open questionWhich of these operators does not perform relative value comparisons?
Select an option to see the answer and solution.
Q695
Open questionWhich header should be included first?
Select an option to see the answer and solution.
Q696
Open questionIn oracle database variable length column is declared by . . . . . . . .
Select an option to see the answer and solution.
Q697
Open questionWhat is the isolation property of transactions?
Select an option to see the answer and solution.
Q698
Open questionWhat is the SQL mode to check for divide by zero error?
Select an option to see the answer and solution.
Q699
Open questionWhat returns a string containing an error message?
Select an option to see the answer and solution.
Q700
Open questionWhich of the following returns a MySQL-specific numeric code?
Select an option to see the answer and solution.