MySQL · all questions

MySQL
practice.

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

1,185

Questions

21/60

Page

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

Q401

For which of these storage engines are configuration options always built?

Select an option to see the answer and solution.

Q402

What is the non handle array representing a row of values?

Select an option to see the answer and solution.

Q403

Which of these has a bigger memory footprint?

Perl, PHP

Select an option to see the answer and solution.

Q404

Which datatype is best suited to store currency values?

Select an option to see the answer and solution.

Q405

Mysql cannot be used to execute script files.

Select an option to see the answer and solution.

Q406

The log enabled by -relay-log-index is . . . . . . . .

Select an option to see the answer and solution.

Q407

The maximum value that can be specified to the size of VARCHAR is . . . . . . . .

Select an option to see the answer and solution.

Q408

A stored procedure is invoked using the statement . . . . . . . .

Select an option to see the answer and solution.

Q409

The statement that suspends the replication related activity of the slave server is . . . . . . . .

Select an option to see the answer and solution.

Q410

The storage in bytes required for VARCHAR(4) type 'abcd' is . . . . . . . .

Select an option to see the answer and solution.

Q411

Accessing data from which of these is faster?

memory, disk

Select an option to see the answer and solution.

Q412

The column attribute provides unique numbers for identification is . . . . . . . .

Select an option to see the answer and solution.

Q413

MySQL supports shared-memory connections on Windows.

Select an option to see the answer and solution.

Q414

Which among the following tags belong to Data definition language?

Select an option to see the answer and solution.

Q415

Which subquery cannot be executed by itself as a separate statement?

Select an option to see the answer and solution.

Q416

Which of these is not a comment specifying construct?

Select an option to see the answer and solution.

Q417

What is the default storage engine?

Select an option to see the answer and solution.

Q418

Which character is illegal in naming an unquoted identifier in SQL?

Select an option to see the answer and solution.

Q419

What is xyz in the following MySQL statement?

CREATE VIEW xyz AS SELECT a, b FROM t;

Select an option to see the answer and solution.

Q420

Which of these has special automatic update behavior?

Select an option to see the answer and solution.

Prev 19 20 21 22 23 Next