Q161
Open questionThe library file that contains various portability macros and definitions 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
9/60
Page
Pick an option on a question to see the right answer and solution.
Q162
Open questionThe most restrictive among the following is . . . . . . . .
mysql_query(), mysql_real_query()Select an option to see the answer and solution.
Q163
Open questionThe largest value to which the variable 'max_allowed_packet' can be set is . . . . . . . .
Select an option to see the answer and solution.
Q164
Open questionUser defined variables are session specific.
Select an option to see the answer and solution.
Q165
Open questionFor which table does 'REPAIR TABLE' not work?
Select an option to see the answer and solution.
Q166
Open questionThe maximum number of elements allowed in SET() is . . . . . . . .
Select an option to see the answer and solution.
Q167
Open questionWhat is the significance of "ORDER BY emp_id DESC" in the following MySQL command?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;Select an option to see the answer and solution.
Q168
Open questionWhat has a higher priority?
writes, readsSelect an option to see the answer and solution.
Q169
Open questionX'61626364' and X'61626364' are respectively . . . . . . . .
Select an option to see the answer and solution.
Q170
Open questionWill the following SQL command produce any error?
INSERT INTO person
(person_id, fname,lname)
VALUES (1,’S’,’U’),
VALUES (2,’T’,’U’);
/* where person_id is a primary key */Select an option to see the answer and solution.
Q171
Open questionWhich among the following is the correct syntax for showing all tables in the database?
Select an option to see the answer and solution.
Q172
Open questionPerl scripts are text files.
Select an option to see the answer and solution.
Q173
Open questionWhich command is used for taking "server side help" in Mysql command line tool?
Select an option to see the answer and solution.
Q174
Open questionWhich privileges are required on the source server to use mysqldbcopy?
Select an option to see the answer and solution.
Q175
Open questionWhich of the following functions are not performed by "ALTER" clause?
Select an option to see the answer and solution.
Q176
Open questionThe server uses a Unix domain socket file for connections by clients to localhost.
Select an option to see the answer and solution.
Q177
Open questionAnonymous accounts have user name . . . . . . . .
Select an option to see the answer and solution.
Q178
Open questionWhich clause names the parent table and the index columns in the table?
Select an option to see the answer and solution.
Q179
Open questionRTF refers to . . . . . . . .
Select an option to see the answer and solution.
Q180
Open questionThe MySQL server is configurable.
Select an option to see the answer and solution.