1Z0-076 practice question 9 of 25

In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE... SET PARAMETER Command: DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace - 1; Which THREE statements are TRUE about the command?

Full set: 107 questions
Answer options
A: The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database. Correct answer
B: The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.
C: The database must be available when the above command is run. Correct answer
D: The value set using this command is directly stored in the broker configuration file.
E: The value set using this command is directly applied to the boston database. Correct answer
Correct Answer:
A. The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.; C. The database must be available when the above command is run.; E. The value set using this command is directly applied to the boston database.
Explanation

The DGMGRL EDIT DATABASE ... SET PARAMETER command is used to manage initialization parameters within a Data Guard configuration.
A. The command works for static parameters by issuing an ALTER SYSTEM ... SCOPE=SPFILE command. The change takes effect upon restart.
C. The broker must be able to connect to the database instance to issue the ALTER SYSTEM command, so the database must be available.
E. The command's primary function is to connect to the specified database instance and execute an ALTER SYSTEM command to apply the parameter change, either to the running instance (for dynamic parameters) or the SPFILE.

Why Incorrect

B. This statement is false. The command can modify both dynamic and static initialization parameters.
D. While the broker configuration is updated to reflect the new parameter setting, the primary action is applying the change to the database itself. The term "directly stored" is less accurate than "directly applied."

References

1. Oracle Data Guard Broker, 19c, Chapter 8, "DGMGRL Command-Line Interface". The documentation for the EDIT DATABASE command states: "The broker propagates the property change to the server parameter file... For a dynamic parameter, the broker also alters the current running instance... The database must be enabled for this command to succeed." This confirms that it works for static parameters (A), requires the database to be available (C), and applies the change to the database (E).

Scroll to Top