When specifying options, which of the following are valid advantages of using options files over parameters on a command line?

The correct answer is A. Options will not need to be specified every time the server starts. B. All options can be consolidated to one file and a single point of reference. Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a program. Table 5.2. System Variable Summary shows that all cmd-line options are also available for the option file with no exclusions.

MySQL Server Administration

Question

Options

AOptions will not need to be specified every time the server starts.
BAll options can be consolidated to one file and a single point of reference.
CCertain options can be specified only in options files but not on the command line

How the community answered

(67 responses)

A
79% (53)
C
21% (14)

Explanation

Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a program. Table 5.2. System Variable Summary shows that all cmd-line options are also available for the option file with no exclusions.

Topics

#option files#my.cnf#configuration management#server startup

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice