N

Nitin Gupta • 1.72K Points
Master 

Q. Which mode exists at both global level and session-specific level?

  • (A) query_mode
  • (B) server_mode
  • (C) key_buffer_size
  • (D) sql_mode
  • Correct Answer - Option(D)
  • Views: 104
  • Filed under category MySQL
Explanation by: Nitin Gupta 
The system variable ‘sql_mode’ that indicates the default SQL mode is an example of a variable that exists at both the global and session levels. This mode affects several aspects of SQL statement processing.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

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

Q. Which is not an aggregate function?

Q. To combine multiple retrievals, which keyword is used to write several SELECT statements between them?

Q. What does UTF stand for int utf8?

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

Q. Which one of the following sorts rows in SQL?

Q. Which is the correct decreasing order for highly developed text manipulation capabilities?

Q. Which of the following is not a query clause?

Q. Which of the following is not a valid aggregate function?

Q. Which of the statement is true?

Learn All MySQL MCQs

Question analytics