Oracle Database MySQL 5.6 Database Administrator — Question 1

Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?

Answer options

• A. Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
• B. Check the command-line options provided for the Mysql Server and compare them with default values.
• 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.

Correct answer: C, D

Explanation

The correct answers are C and D because both methods provide a direct way to view the current global variables and their values, allowing for a comparison to the defaults. Options A and B focus on configuration files and command-line parameters, which may not reflect the currently running settings as accurately as querying the server directly.