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: 99
  • 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. Is it possible to define a NOT NULL field in a record?

Q. What loads data files into tables?

Q. The log that identifies statements that may be in need of being rewritten for better performance is . . . . . . . .

Q. The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

Q. What is the property of InnoDB that enforces foreign key relationships stay intact?

Q. Which of these is also known as a virtual table?

Q. The indicator of presence/absence of a word in search is used in the mode . . . . . . . .

Q. Which of the following keywords cannot be used to modify an existing table?

Q. Which clause is used to determine "which column to include in the query sets"?

Q. INFORMATION_SCHEMA is more portable than SHOW statements.

Learn All MySQL MCQs

Question analytics