Q1061
Open questionWhich mode prevents MySQL to perform full checking of date parts?
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
54/60
Page
Pick an option on a question to see the right answer and solution.
Q1062
Open questionWhich among the following data types can be used with "Range Condition"?
Select an option to see the answer and solution.
Q1063
Open questionHow many of the following is (are) considered as a special character by 'mysql_real_escape_string()'?
null byte, single quote, backslashSelect an option to see the answer and solution.
Q1064
Open questionWhich clause is used to sort a UNION result as a whole?
Select an option to see the answer and solution.
Q1065
Open questionWhich statement exits a labeled flow-control construct?
Select an option to see the answer and solution.
Q1066
Open questionA view can be deleted using the command . . . . . . . .
Select an option to see the answer and solution.
Q1067
Open questionThe system variable 'system_time_zone' can be reset at runtime.
Select an option to see the answer and solution.
Q1068
Open questionThe mode of search is the search string parsed into words and the search looks for rows is . . . . . . . .
Select an option to see the answer and solution.
Q1069
Open questionDoes the following MySQL statement belong to the "Inequality condition"?
SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name! =’customers_accounts’;Select an option to see the answer and solution.
Q1070
Open questionThe ALL subquery performs operations on . . . . . . . .
Select an option to see the answer and solution.
Q1071
Open questionWhen no modes are enabled, what does this SQL statement return?
SELECT @@SESSION.sql_mode;Select an option to see the answer and solution.
Q1072
Open questionWhat causes a replication master server to delete all the binary log files even if they are still in use?
Select an option to see the answer and solution.
Q1073
Open questionWhich of these can be used to generate hash values?
Select an option to see the answer and solution.
Q1074
Open questionWhat is x in the following MySQL statement?
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;Select an option to see the answer and solution.
Q1075
Open questionWhat is the default format for "Date" data type?
Select an option to see the answer and solution.
Q1076
Open questionWhich of these is a stored program associated with a schedule?
Select an option to see the answer and solution.
Q1077
Open questionWhat is the meaning of "NULL" in Mysql?
Select an option to see the answer and solution.
Q1078
Open questionThe data rows of a MyISAM table are stored in . . . . . . . .
Select an option to see the answer and solution.
Q1079
Open questionThe statement that is used to check the status of the event scheduler at runtime is . . . . . . . .
Select an option to see the answer and solution.
Q1080
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.