Q201
Open questionWhich program performs logical backups?
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
11/60
Page
Pick an option on a question to see the right answer and solution.
Q202
Open questionWhich variable is used as a handle to an open file?
Select an option to see the answer and solution.
Q203
Open questionIf the storage engine InnoDB is not used, foreign key cannot be used.
Select an option to see the answer and solution.
Q204
Open questionWhat will be the output of the following MySQL command?
SELECT fname
FROM person
WHERE emp_id != 6 OR emp_id IS NULL;Select an option to see the answer and solution.
Q205
Open questionThe myisamchk variable that represents the size of buffer used to hold index blocks is . . . . . . . .
Select an option to see the answer and solution.
Q206
Open questionCharacter data can be stored as . . . . . . . .
Select an option to see the answer and solution.
Q207
Open questionWhat is the creation of a stored program similar to?
Select an option to see the answer and solution.
Q208
Open questionMySQL does not provide a date type that has an optional time part.
Select an option to see the answer and solution.
Q209
Open questionWhat will happen if the data being loaded into a text column exceeds the maximum size of that type?
Select an option to see the answer and solution.
Q210
Open questionFor REVOKE statements, the server automatically rereads the grant tables.
Select an option to see the answer and solution.
Q211
Open questionWhat can be used to check for views that have been invalidated by DROP or ALTER operations?
Select an option to see the answer and solution.
Q212
Open questionWhat will be the output of the following MySQL command?
SELECT *
FROM person
WHERE emp_id = NULL;Select an option to see the answer and solution.
Q213
Open questionThe maximum collations a character set can have is . . . . . . . .
Select an option to see the answer and solution.
Q214
Open questionWhich option is necessary to compile a C program havin math functions?
Select an option to see the answer and solution.
Q215
Open questionWhat will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’;Select an option to see the answer and solution.
Q216
Open questionHow many of the following shared tablespaces is bound by the OS file size limit?
MyISAM, InnoDB, TRANSACTIONSelect an option to see the answer and solution.
Q217
Open questionThe command which lists databases managed by the server is . . . . . . . .
Select an option to see the answer and solution.
Q218
Open questionWhat default value gets stored in columns of the table?
Select an option to see the answer and solution.
Q219
Open questionWhich among the following tags belong to Data Manipulation language?
Select an option to see the answer and solution.
Q220
Open questionTriggers enable to enforce data integrity constraints.
Select an option to see the answer and solution.