Oracle
1Z0-883 · Question #67
Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?
The correct answer is C. Check the output of SHOW GLOBAL VARIABLES and compare it with default values. D. Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values. Even though parameter passed in command-line when start server, we can change the values later in mysql shell.
MySQL Configuration and Architecture
Question
Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?
Options
- ACheck the configuration files in the order in which they are read by the Mysql Server and compare them
- BCheck the command-line options provided for the Mysql Server and compare them with default values.
- CCheck the output of SHOW GLOBAL VARIABLES and compare it with default values.
- DQuery the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.
How the community answered
(55 responses)- A11% (6)
- B5% (3)
- C84% (46)
Explanation
Even though parameter passed in command-line when start server, we can change the values later in mysql shell.
Topics
#SHOW GLOBAL VARIABLES#INFORMATION_SCHEMA#system variables#server configuration
Community Discussion
No community discussion yet for this question.