Oracle
1Z0-883 · Question #85
You adjust a default configuration to the following /etc/my.cnf on a Linux installation: [mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your…
The correct answer is D. Mysqld prints to the error log about an unknown variable, and then exits. See the full explanation below for the reasoning.
Question
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:
[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?
Options
- AMysqld uses internal configuration versioning and reverts to the previous configuration.
- BWhen using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.
- CThe mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.
- DMysqld prints to the error log about an unknown variable, and then exits.
How the community answered
(27 responses)- A4% (1)
- B4% (1)
- C15% (4)
- D78% (21)
Community Discussion
No community discussion yet for this question.