MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

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

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

A. STRICT_ALL_TABLES

B. STRICT_TRANS_TABLES

C. TRADITIONAL

D. ERROR_WHEN_DIVIDE_BY_ZERO

Answer & Solution Discuss in Board Save for Later

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

A. IN and NOT IN

B. EXISTS and NOT EXISTS

C. OUTER JOIN and INNER JOIN

D. LEFT JOIN and RIGHT JOIN

Answer & Solution Discuss in Board Save for Later

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

A. WHERE

B. FROM

C. ALTER

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

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

A. True

B. Null

C. False

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

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

A. SHOW STATUS OF 'event_scheduler'

B. SHOW VARIABLES OF 'event_scheduler'

C. SHOW STATUS LIKE 'event_scheduler'

D. SHOW VARIABLES LIKE 'event_scheduler'

Answer & Solution Discuss in Board Save for Later

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

A. PROCESS

B. PROCESSLIST

C. LIST

D. THREADSLIST

Answer & Solution Discuss in Board Save for Later

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

A. libmysqla

B. libmysqlb

C. libmysqlc

D. libmysqld

Answer & Solution Discuss in Board Save for Later

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

A. SELECT

B. WHERE

C. FROM

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

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

A. -1

B. 0

C. 1

D. 2

Answer & Solution Discuss in Board Save for Later

50.
What does 'mysql_query()' return on failure?

A. 0

B. 1

C. -1

D. a non-zero value

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MySQL mcq questions and answers | MySQL MCQs

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

50. What does 'mysql_query()' return on failure?

Answer & Solution

Read More Section(MySQL Miscellaneous)

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

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

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

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

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

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

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

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

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

50.
What does 'mysql_query()' return on failure?