MySQL · all questions

MySQL
practice.

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

1,185

Questions

14/60

Page

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

Q261

Which line is written at the top of the script to write a Perl script using CGI.pm?

Select an option to see the answer and solution.

Q262

The search mode that uses natural language search as a subroutine is . . . . . . . .

Select an option to see the answer and solution.

Q263

What is the meaning of "Temporary Tables" in Mysql?

Select an option to see the answer and solution.

Q264

The header that should be included first is . . . . . . . .

Select an option to see the answer and solution.

Q265

Bulk loading is less efficient than single row loading.

Select an option to see the answer and solution.

Q266

Which among the following operators is/are belongs to "Inequality conditions"?

Select an option to see the answer and solution.

Q267

The property of InnoDB that enforces foreign key relationships stay intact is called . . . . . . . .

Select an option to see the answer and solution.

Q268

CGI.pm does not support an object oriented style of use.

Select an option to see the answer and solution.

Q269

What will be the output of the following MySQL command?

SELECT fname
FROM person
WHERE emp_id != 6;

Select an option to see the answer and solution.

Q270

Which option is supplied to ensure TCP/IP connection to local server?

Select an option to see the answer and solution.

Q271

SPATIAL indexes cannot be created on NOT NULL spatial columns.

Select an option to see the answer and solution.

Q272

What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE %t%f%n%;

Select an option to see the answer and solution.

Q273

Which of these is preferred when stored procedures are not being used?

CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

Select an option to see the answer and solution.

Q274

Which among the following have the maximum bytes?

Select an option to see the answer and solution.

Q275

The numbers that are prefixed with '0x' are in base . . . . . . . .

Select an option to see the answer and solution.

Q276

The date and time datatype that stores time value in 'hh:mm:ss' format is . . . . . . . .

Select an option to see the answer and solution.

Q277

What is the mantissa in -1.58E5?

Select an option to see the answer and solution.

Q278

In PHP, how is the first element accessed if $a represents an array with numeric indices?

Select an option to see the answer and solution.

Q279

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?

SELECT emp_id
FROM person
ORDER BY emp_id;

Select an option to see the answer and solution.

Q280

To use 'mysqldbcopy' which privileges are required on the source server?

Select an option to see the answer and solution.

Prev 12 13 14 15 16 Next