Q221
Open questionWhich keyword inserted in the SHOW STATUS statement shows the values for the current connection?
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
12/60
Page
Pick an option on a question to see the right answer and solution.
Q222
Open questionWhat is the need of "column Aliases" in "SELECT" clause?
Select an option to see the answer and solution.
Q223
Open questionIn the following MySQL command how many rows will be deleted?
DELETE person
WHERE person_id<10;
/*person_id is a primary key */Select an option to see the answer and solution.
Q224
Open questionThe following MySQL statement belongs to which condition types?
SELECT fname
FROM person
WHERE fed_id=’111-11-111’;Select an option to see the answer and solution.
Q225
Open questionThe function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .
Select an option to see the answer and solution.
Q226
Open questionWhich variable is used to set table alias names as non-case sensitive?
Select an option to see the answer and solution.
Q227
Open questionWhich keyword is used to search through natural language fulltext?
Select an option to see the answer and solution.
Q228
Open questionWhat is 'xyz' in the following SQL statement?
SELECT xyz FROM table1 UNION xyz FROM table2;Select an option to see the answer and solution.
Q229
Open questionThe function that returns a reference to an array of row values is . . . . . . . .
Select an option to see the answer and solution.
Q230
Open questionThe statement used to remove indexes on tables is . . . . . . . .
Select an option to see the answer and solution.
Q231
Open questionWhich among the following can also be included with "SELECT" clause while writing query in Mysql?
Select an option to see the answer and solution.
Q232
Open questionWhich among the following are the correct representation of "float(4,2)"?
Select an option to see the answer and solution.
Q233
Open questionWhich statement is used to remove indexes on tables?
Select an option to see the answer and solution.
Q234
Open questionWhat is the general statement-issuing routine?
Select an option to see the answer and solution.
Q235
Open questionWhat is the output from PHP?
Select an option to see the answer and solution.
Q236
Open questionWhich character set variable indicates the character set used for storing identifiers?
Select an option to see the answer and solution.
Q237
Open questionThe grant table that stores users who can connect to the server and their global privileges are . . . . . . . .
Select an option to see the answer and solution.
Q238
Open questionWhich storage engine enables to access tables from a MySQL server managed by another server?
Select an option to see the answer and solution.
Q239
Open questionWhat will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);Select an option to see the answer and solution.
Q240
Open questionTo measure the length of a string in bytes, the operator used is . . . . . . . .
Select an option to see the answer and solution.