MySQL · all questions

MySQL
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

1,185

Questions

8/60

Page

Pick an option on a question to see the right answer and solution.

Q141

Which Numeric Data type has the largest range?

Select an option to see the answer and solution.

Q142

If the operands are non binary strings, LIKE compares them according to their collation.

Select an option to see the answer and solution.

Q143

Which clause is used to determine "which column to include in the query sets"?

Select an option to see the answer and solution.

Q144

Which myisamchk variable represents the size of buffer used to hold index blocks?

Select an option to see the answer and solution.

Q145

Which command is used in Mysql command line tool to return to window command shell?

Select an option to see the answer and solution.

Q146

Select the sequence for how the query mechanism works?

Select an option to see the answer and solution.

Q147

Which key declares that an index in one table is related to that in another?

Select an option to see the answer and solution.

Q148

The statement that alters an existing event to have the given definition is . . . . . . . .

Select an option to see the answer and solution.

Q149

In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?

Select an option to see the answer and solution.

Q150

Which one is the correct declaration for choosing the character set other than default?

Select an option to see the answer and solution.

Q151

fetchrow_hashref() returns reference to hash of row values keyed by . . . . . . . .

Select an option to see the answer and solution.

Q152

In which file are the statements entered in 'mysql' saved?

Select an option to see the answer and solution.

Q153

Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . .

SELECT tbl_1.i1, tbl_2.i2
	FROM tbl_1 INNER JOIN tbl_2
	WHERE tbl_1.i1 = tbl_2.i2;

Select an option to see the answer and solution.

Q154

Which table lists the accounts and the databases for which the privileges are provided?

Select an option to see the answer and solution.

Q155

What is the shebang line?

Select an option to see the answer and solution.

Q156

What can be used interchangeably with MYSQL_VERSION_ID?

Select an option to see the answer and solution.

Q157

The number of tables among the following for which HIGH_PRIORITY have an effect are . . . . . . . .

MyISAM, MEMORY, MERGE

Select an option to see the answer and solution.

Q158

The MySQL clients are linked with . . . . . . . .

Select an option to see the answer and solution.

Q159

CGI stands for . . . . . . . .

Select an option to see the answer and solution.

Q160

There can be more than one column per table with the AUTO_INCREMENT attribute.

Select an option to see the answer and solution.

Prev 6 7 8 9 10 Next