Q: 19
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?
Options
Discussion
Probably B, C, E. Based on the official docs and similar exam/practice questions, only dynamic parameters can be edited while the DB is up (C), and changes apply directly to the specified DB (E). If you're not sure, Oracle's admin guide covers this.
B/C/E tbh, matches what I've seen. The EDIT DATABASE ... SET PARAMETER is used for dynamic params, and the db needs to be open so C makes sense. E is right since it applies directly to the Boston DB, not just broker files. Pretty sure static params won't work here unless you bounce the instance. Let me know if I missed something.
B/C/E for me, since DGMGRL's EDIT DATABASE ... SET PARAMETER is mainly for dynamic parameters and the DB needs to be online (so C). The actual update goes to the Boston DB (E), not just broker config files. Not 100% on the static param bit but that's how I've always seen it work in practice. Disagree?
B/C/E? Annoying how Oracle buries these DGMGRL quirks. Similar question on practice-dynamic params only, db must be up, and it changes the db directly (not just broker files). If you pick static, it'll fail unless you restart. Unless I missed something.
Option B C, and E fit here. EDIT DATABASE PARAMETER updates dynamic params and the database has to be online to apply them. The value goes straight to the actual database not just config. Pretty sure that's correct.
Be respectful. No spam.
