Q: 15
Examine the following parameter settings of the physical standby database:
• STANDBY_FILE_MANAGEMENT=AUTO
• ENABLED_PDBS_ON_STANDBY=
During which TWO tasks are files automatically created in the physical standby database after
structure changes on the primary database?
Options
Discussion
C/D? I see why people consider E, but in most official Oracle docs with STANDBY_FILE_MANAGEMENT=AUTO, files are auto-created on standby only when you add a datafile or create a tablespace (C), or create a PDB (D). Renaming (E) usually just changes the control file reference, unless it's a new path with no file-which feels like an edge case and not always expected. Pretty sure it's C and D, but happy to hear other takes.
E , had something like this in a mock and picked E with C.
Option C and D, but technically if you rename a datafile to a non-existent path (E), standby might create it. Depends on if the file physically exists or not. Torn here, anyone else read E as valid sometimes?
Oracle wording drives me nuts on these. Probably C and D, that's what shows up in similar question pools and docs, but the rename file (E) part is always weirdly phrased.
D imo. C and D are the two where files get *automatically* created on the standby, since adding a datafile or a PDB actually triggers standby file creation when STANDBY_FILE_MANAGEMENT=AUTO. E is tempting, but renaming just updates pointers unless you point to a new path with no existing file-which isn't always the case. Easy to get tripped up with E here. Disagree?
Probably E , since renaming a data file could sometimes create files on standby if the path didn’t exist before. That’s how I learned it, unless I’m missing something here.
C/D? I keep seeing practice sets put both for this but not 100 percent sure if D always fits. Anyone else get this exact combo marked right on an official exam dump?
Option E, Renaming a data file also triggers file activity on standby, right? This can sometimes create files depending how it's done.
Be respectful. No spam.
