MySQL mcq questions and answers | MySQL MCQs Page-6 section-12

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

51.

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-23;

A. All columns

B. Only those columns which are mention with "SELECT" clause

C. Columns mention with "SELECT" clause and only those rows which contain 'HEAD TELLER' as a "title" and start_date>2008-11-23

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

52.

Which of these is faster when accessing data?

memory, disk

A. memory

B. disk

C. same speed

D. machine dependent

Answer & Solution Discuss in Board Save for Later

53.
Which variable when set to 1 would enable foreign key checking for InnoDB tables?

A. error_count

B. identity

C. foreign_key_checks

D. autocommit

Answer & Solution Discuss in Board Save for Later

54.

How many among the following does not return a value?

mysql_close(), mysql_init, mysql_real_connect

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

55.
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

A. fast_queue_size

B. general_queue_size

C. slow_queue_size

D. delayed_queue_size

Answer & Solution Discuss in Board Save for Later

56.
On failure, 'mysql_query()' returns . . . . . . . .

A. 0

B. 1

C. -1

D. a non-zero value

Answer & Solution Discuss in Board Save for Later

57.
The number of values returned from a stored procedure can be . . . . . . . .

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

58.

If in Table "account", a column "cust_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

SELECT DISTINICT cust_id
FROM account;

A. {1, 2, 2, 3, 3, 5, 6, 7, 8, 8}

B. {1, 2, 3, 5, 6, 7, 8}

C. { }

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

59.
What does UTF stand for int utf8?

A. Universal Transformation Format

B. Unicode Transformation Format

C. Universal Transformation Formula

D. Unicode Transformation Formula

Answer & Solution Discuss in Board Save for Later

60.
The binary protocol does not support all statements.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9

51.
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-23;`

Answer & Solution

52.
Which of these is faster when accessing data?
`memory, disk`

Answer & Solution

53.
Which variable when set to 1 would enable foreign key checking for InnoDB tables?

Answer & Solution

54.
How many among the following does not return a value?

`mysql_close(), mysql_init, mysql_real_connect`

Answer & Solution

55.
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

Answer & Solution

56.
On failure, 'mysql_query()' returns . . . . . . . .

Answer & Solution

57.
The number of values returned from a stored procedure can be . . . . . . . .

Answer & Solution

58.
If in Table "account", a column "cust_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

`SELECT DISTINICT cust_id FROM account;`

Answer & Solution

59.
What does UTF stand for int utf8?

Answer & Solution

60.
The binary protocol does not support all statements.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

51. 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-23;

Answer & Solution

52. Which of these is faster when accessing data?memory, disk

Answer & Solution

53. Which variable when set to 1 would enable foreign key checking for InnoDB tables?

Answer & Solution

54. How many among the following does not return a value? mysql_close(), mysql_init, mysql_real_connect

Answer & Solution

55. Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

Answer & Solution

56. On failure, 'mysql_query()' returns . . . . . . . .

Answer & Solution

57. The number of values returned from a stored procedure can be . . . . . . . .

Answer & Solution

58. If in Table "account", a column "cust_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement? SELECT DISTINICT cust_id FROM account;

Answer & Solution

59. What does UTF stand for int utf8?

Answer & Solution

60. The binary protocol does not support all statements.

Answer & Solution

Read More Section(MySQL Miscellaneous)

51.
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-23;`

52.
Which of these is faster when accessing data?
`memory, disk`

53.
Which variable when set to 1 would enable foreign key checking for InnoDB tables?

54.
How many among the following does not return a value?

`mysql_close(), mysql_init, mysql_real_connect`

55.
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

56.
On failure, 'mysql_query()' returns . . . . . . . .

57.
The number of values returned from a stored procedure can be . . . . . . . .

58.
If in Table "account", a column "cust_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

`SELECT DISTINICT cust_id FROM account;`

59.
What does UTF stand for int utf8?

60.
The binary protocol does not support all statements.