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 questionsThe 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.
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."
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).
Keep practicing
Take the free 1Z0-076 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-076 practice questions
- Question 2You created two remote physical standby databases using SQL and RMAN. The primary databas…
- Question 3Examine the Data Guard configuration: DGMGRL> show configuration; Configuration - Animals…
- Question 4Your expertise is requested for these customer requirements: The Data Guard environment m…
- Question 5Which THREE steps are prerequisites for the creation of a physical standby database on a …
- Question 6You must design an Oracle Data Guard configuration for a DSS database that meets these pe…
- Question 7Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) proces…
