MySQL · all questions

MySQL
practice.

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

1,185

Questions

44/60

Page

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

Q861

Is the following statement is true/false?
"An expression can be NULL, but can never equal to NULL"

Select an option to see the answer and solution.

Q862

Which command is used to create "Temporary tables" in MySQL?

Select an option to see the answer and solution.

Q863

Which procedure parameter enables the caller to pass in a value and get back a value?

Select an option to see the answer and solution.

Q864

What is the significance of the statement "HAVING COUNT (emp_id)>2" in the following MySQL statement?

SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
HAVING COUNT (emp_id)>2

Select an option to see the answer and solution.

Q865

The option necessary to compile a C program havin math functions is . . . . . . . .

Select an option to see the answer and solution.

Q866

The mode that does not remove trailing spaces when CHAR values are retrieved is . . . . . . . .

Select an option to see the answer and solution.

Q867

PHP scripts are located in the web server document tree.

Select an option to see the answer and solution.

Q868

Which of the following statements is/are correct?

Select an option to see the answer and solution.

Q869

In which directory are the DBI scripts located?

Select an option to see the answer and solution.

Q870

The clause that is used to display information that matches a given pattern is . . . . . . . .

Select an option to see the answer and solution.

Q871

In which mode is the indicator of the presence/absence of a word in search used?

Select an option to see the answer and solution.

Q872

The column not returned by 'OPTIMIZE TABLE' is . . . . . . . .

Select an option to see the answer and solution.

Q873

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 command?

SELECT emp_id
FROM person
ORDER BY emp_id DESC;

Select an option to see the answer and solution.

Q874

MySQL provides a date type that has an optional time part.

Select an option to see the answer and solution.

Q875

There is a startup penalty for a standalone interpreter.

Select an option to see the answer and solution.

Q876

"CREATE TABLE ..." command is used to create which type of table in Mysql?

Select an option to see the answer and solution.

Q877

What sets the association between one or more MyISAM tables and the named key cache?

Select an option to see the answer and solution.

Q878

The one that is more restrictive is . . . . . . . .

mysql_query(), mysql_real_query()

Select an option to see the answer and solution.

Q879

The keyword used with UNION that retains duplicate rows is . . . . . . . .

Select an option to see the answer and solution.

Q880

What is 'xyz' in the following SQL statement?

SELECT abc FROM xyz;

Select an option to see the answer and solution.

Prev 42 43 44 45 46 Next