Q1021
Open questionWhich clause is used with an "aggregate functions"?
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
52/60
Page
Pick an option on a question to see the right answer and solution.
Q1022
Open questionWhich option enables multiple-statement execution?
Select an option to see the answer and solution.
Q1023
Open questionWhat is the default path to Perl in Unix?
Select an option to see the answer and solution.
Q1024
Open questionWhich among the following is the correct syntax for defining "ENUM" in Mysql?
Select an option to see the answer and solution.
Q1025
Open questionWhich statement is valid if '`sampledb`' is a database and '`tbl`' is a table in it?
Select an option to see the answer and solution.
Q1026
Open questionThe information about table index characteristics is stored in which table of INFORMATION_SCHEMA?
Select an option to see the answer and solution.
Q1027
Open questionThe mysql client writes a record of executed statements to a history file on Unix.
Select an option to see the answer and solution.
Q1028
Open questionWhat are X'61626364? and X'61626364??
Select an option to see the answer and solution.
Q1029
Open questionStored programs refer to stored objects of how many of the following types?
functions, procedures, triggers, eventsSelect an option to see the answer and solution.
Q1030
Open questionHow many of the following languages can interface to bind to the C API of MySQL?
Perl, PHP, PythonSelect an option to see the answer and solution.
Q1031
Open questionWhich table in INFORMATION_SCHEMA stores information about storage engines and server plugins?
Select an option to see the answer and solution.
Q1032
Open questionWhich of the following is used on Solaris?
Select an option to see the answer and solution.
Q1033
Open questionThe slave stores the CHANGE MASTER parameters in the file . . . . . . . .
Select an option to see the answer and solution.
Q1034
Open questionHow many of the following attributes are allowed only for numeric types?
UNSIGNED, ZEROFILL, CHARACTER SET, COLLATESelect an option to see the answer and solution.
Q1035
Open questionThe REAL type is synonym for . . . . . . . .
Select an option to see the answer and solution.
Q1036
Open questionThe operator that compares sounds is . . . . . . . .
Select an option to see the answer and solution.
Q1037
Open questionIn a single table (with 10 columns) join query the number of values needed to examine per column is . . . . . . . .
Select an option to see the answer and solution.
Q1038
Open questionThe program that performs logical backups is . . . . . . . .
Select an option to see the answer and solution.
Q1039
Open questionThe value of recently generated sequence number can be obtained by . . . . . . . .
Select an option to see the answer and solution.
Q1040
Open questionWhat does 'C' stand for in the ACID property of transactions?
Select an option to see the answer and solution.