Q761
Open questionThe minimum value stored by signed TINYINT 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
39/60
Page
Pick an option on a question to see the right answer and solution.
Q762
Open questionWhat does comparing a known value with NULL result into?
Select an option to see the answer and solution.
Q763
Open questionTriggers and events are not invoked automatically by the server.
Select an option to see the answer and solution.
Q764
Open questionWhich keyword is used for sorting the data in descending order in Mysql?
Select an option to see the answer and solution.
Q765
Open questionWhich data type character merges the "Check Constraint" into a data type definition?
Select an option to see the answer and solution.
Q766
Open questionWhich option is used in 'mysqldump' to make all tables in the destination databases to use a different storage engine?
Select an option to see the answer and solution.
Q767
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.
Q768
Open questionThe output from PHP is . . . . . . . .
Select an option to see the answer and solution.
Q769
Open questionxyz in the following MySQL statement is . . . . . . . .
CREATE VIEW xyz AS SELECT a, b FROM t;Select an option to see the answer and solution.
Q770
Open questionThe mode of search in which the search string is parsed into words and the search looks for rows is . . . . . . . .
Select an option to see the answer and solution.
Q771
Open questionThe number of legal hexadecimal values among 0x0a, 0x0A, 0X0a and 0X0A is . . . . . . . .
Select an option to see the answer and solution.
Q772
Open questionWhat is exec_stmt_ssl written in?
Select an option to see the answer and solution.
Q773
Open questionWhich statement is used to show the server's current character set and collation settings?
Select an option to see the answer and solution.
Q774
Open questionWhat is the return value from operations returning a row count?
Select an option to see the answer and solution.
Q775
Open questionHow is a delimited-text data file reloaded?
Select an option to see the answer and solution.
Q776
Open questionThe LOCAL capability for LOAD DATA does not need to be enabled explicitly.
Select an option to see the answer and solution.
Q777
Open questionUnder which option are index changes not flushed until tables close?
Select an option to see the answer and solution.
Q778
Open questionThe expression '2 BETWEEN 2 AND 5' results in . . . . . . . .
Select an option to see the answer and solution.
Q779
Open questionWhich statement is used to produce a stored function?
Select an option to see the answer and solution.
Q780
Open questionWhat will be the output of the following MySQL statement "true OR Null"?
Select an option to see the answer and solution.