Q1141
Open questionWhich function returns reference to array of row values?
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
58/60
Page
Pick an option on a question to see the right answer and solution.
Q1142
Open questionEach language binding defines its own interface for accessing MySQL.
Select an option to see the answer and solution.
Q1143
Open questionWhat sets up an association between one or more MyISAM tables and the named key cache?
Select an option to see the answer and solution.
Q1144
Open questionWhat is generally used as a synonym for CHARACTER SET?
Select an option to see the answer and solution.
Q1145
Open questionWhich of these is the metadata log?
Select an option to see the answer and solution.
Q1146
Open questionWhich among the following is an optional Keyword?
Select an option to see the answer and solution.
Q1147
Open questionIn the CREATE TABLE statement, the engine name specified is case insensitive.
Select an option to see the answer and solution.
Q1148
Open questionThe default index type for MEMORY tables is . . . . . . . .
Select an option to see the answer and solution.
Q1149
Open questionWhich keyword is the synonym for DATABASE?
Select an option to see the answer and solution.
Q1150
Open questionHow many digits is the DECIMAL used for expressions containing only exact values with fractional part?
Select an option to see the answer and solution.
Q1151
Open questionWhat will be the output of the following MySQL command?
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’ AND start_date>2008-11-23;Select an option to see the answer and solution.
Q1152
Open questionWhich of these is faster when accessing data?
memory, diskSelect an option to see the answer and solution.
Q1153
Open questionWhich variable when set to 1 would enable foreign key checking for InnoDB tables?
Select an option to see the answer and solution.
Q1154
Open questionHow many among the following does not return a value?
mysql_close(), mysql_init, mysql_real_connectSelect an option to see the answer and solution.
Q1155
Open questionWhich system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?
Select an option to see the answer and solution.
Q1156
Open questionOn failure, 'mysql_query()' returns . . . . . . . .
Select an option to see the answer and solution.
Q1157
Open questionThe number of values returned from a stored procedure can be . . . . . . . .
Select an option to see the answer and solution.
Q1158
Open questionIf in Table "account", a column "cust_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 cust_id
FROM account;Select an option to see the answer and solution.
Q1159
Open questionWhat does UTF stand for int utf8?
Select an option to see the answer and solution.
Q1160
Open questionThe binary protocol does not support all statements.
Select an option to see the answer and solution.