MySQL · all questions

MySQL
practice.

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

1,185

Questions

28/60

Page

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

Q541

What is the significance of "ORDER BY emp_id ASC" in the following MySQL command?

SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id ASC;

Select an option to see the answer and solution.

Q542

Which is the header that should be included first?

Select an option to see the answer and solution.

Q543

The number of files that each end of a client/server connection including SSL support use to set up secure communications is . . . . . . . .

Select an option to see the answer and solution.

Q544

INFORMATION_SCHEMA is not based on the SQL standard.

Select an option to see the answer and solution.

Q545

The Audit_log_events system variable is of type . . . . . . . .

Select an option to see the answer and solution.

Q546

In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is . . . . . . . .

Select an option to see the answer and solution.

Q547

The option which delays index flushing for slave server is . . . . . . . .

Select an option to see the answer and solution.

Q548

INT2 maps to MySQL type . . . . . . . .

Select an option to see the answer and solution.

Q549

When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns . . . . . . . .

Select an option to see the answer and solution.

Q550

Which of these types store the longest length of strings?

Select an option to see the answer and solution.

Q551

The escape sequence for carriage return is . . . . . . . .

Select an option to see the answer and solution.

Q552

Loading is faster when a table has no indexes than when it is indexed.

Select an option to see the answer and solution.

Q553

The datatype that means a variable length non binary string is . . . . . . . .

Select an option to see the answer and solution.

Q554

What 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-24;

Select an option to see the answer and solution.

Q555

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

Select an option to see the answer and solution.

Q556

What is abc in the following MySQL statement?

DECLARE abc HANDLER FOR def ghi;

Select an option to see the answer and solution.

Q557

Usage of aggregates in WHERE clause is allowed.

Select an option to see the answer and solution.

Q558

Which of these operators perform similar operations like ALL and ANY?

Select an option to see the answer and solution.

Q559

Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

Select an option to see the answer and solution.

Q560

What is ghi in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

Select an option to see the answer and solution.

Prev 26 27 28 29 30 Next