The system variable in MySQL server that enables to configure the SQL mode is . . . . . . . .
A. sql_config
B. sql_mode
C. sql_server
D. sql_enable
Answer: Option B
Solution(By Examveda Team)
The system variable in MySQL server that enables configuring the SQL mode is sql_mode.This variable allows users to set various options that determine the SQL mode behavior, such as strict mode, which controls how MySQL handles invalid or missing data in queries.
Option A, sql_config, is incorrect because there is no system variable named sql_config in MySQL for configuring the SQL mode.
Option C, sql_server, is incorrect because the SQL mode is a configuration specific to MySQL server, but there is no system variable named sql_server for this purpose.
Option D, sql_enable, is incorrect because there is no system variable named sql_enable in MySQL for configuring the SQL mode.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion