MySQL · all questions

MySQL
practice.

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

1,185

Questions

33/60

Page

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

Q641

Which mode is a shorthand for 'both strict modes plus a bunch of other restrictions'?

Select an option to see the answer and solution.

Q642

Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

Select an option to see the answer and solution.

Q643

Which Clause is used to select a particular row from the set of row in an existing table?

Select an option to see the answer and solution.

Q644

What will be the output of the following MySQL statement "Null AND Null"?

Select an option to see the answer and solution.

Q645

Which statement is used to check the status of the event scheduler at runtime?

Select an option to see the answer and solution.

Q646

Which table stores information about the threads executing within the server?

Select an option to see the answer and solution.

Q647

What is the embedded server library containing the MySQL server linkable into applications?

Select an option to see the answer and solution.

Q648

Which clause is similar to "HAVING" clause in Mysql?

Select an option to see the answer and solution.

Q649

What does LAST_INSERT_ID() return when no AUTO_INCREMENT value has been generated during the current connection?

Select an option to see the answer and solution.

Q650

What does 'mysql_query()' return on failure?

Select an option to see the answer and solution.

Q651

Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.

Select an option to see the answer and solution.

Q652

The "Mysql command line tool" formats are bounded by . . . . . . . .

Select an option to see the answer and solution.

Q653

The MySQL server used in its client/server architecture is . . . . . . . .

Select an option to see the answer and solution.

Q654

Is "GROUP BY" clause is similar to "ORDER BY" clause?

Select an option to see the answer and solution.

Q655

For how many of the following do interfaces exist for implementing direct native client-server protocol?

Java, PHP, Ruby

Select an option to see the answer and solution.

Q656

MySQL works with spatial values in 3 formats.

Select an option to see the answer and solution.

Q657

Which command is used to make a script file 'run_me.sh' executable?

Select an option to see the answer and solution.

Q658

Which data type is more suitable for storing "documents" in Mysql?

Select an option to see the answer and solution.

Q659

Which of the following clause is evaluated in the last by database server?

Select an option to see the answer and solution.

Q660

Which program copies the databases from one server to another?

Select an option to see the answer and solution.

Prev 31 32 33 34 35 Next