📊 MySQL
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
💬 Discuss
✅ Correct Answer: (D) sql_mode

Explanation: 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.

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.

💬 Discussion

📊 Question Analytics

👁️
181
Total Visits
📽️
4 y ago
Published
🎖️
Nitin Gupta
Publisher
📈
89%
Success Rate