Q: 2
You have a Data Guard Broker configuration called 'Somewhere' as shown:
DGMGRL> SHOW CONFIGURATION;
Configuration - Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby - Primary database
FS - Far Sync
Farout - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You then run this command:
DGMGRL> SHOW DATABASE 'Nearby' 'InconsistentProperties';
Which two are true about the output of this DGMGRL command?
Options
Discussion
Had something like this in a mock before and the correct combo was A and D. Far sync can't have its own inconsistent properties, and "SHOW DATABASE 'InconsistentProperties'" checks the DB instance vs its spfile/runtime, not vs other DBs. Pretty sure about these two, but happy to see if anyone spots a gap.
For me, B. The wording says it checks for properties inconsistent between databases, so it sounds like 'Nearby' vs 'Farout' would make sense here. I think SHOW DATABASE 'InconsistentProperties' could be looking at database-level config differences, not just internal to Nearby. Anyone disagree?
B or D, kinda see reasoning for both but not sure which is better here.
Its A and D. Saw similar on practice tests, check the official Oracle guide for details.
A and D. No explanation needed here.
A and D imo. The "InconsistentProperties" check looks at whether Nearby's broker config matches its own server parameter file or instance values, not comparing with Farout. Far Sync doesn't have database properties to be inconsistent. There's a subtle catch since some assume B but that's not the intent here. Correct me if I'm off.
A and D tbh. A works because far sync instances don't hold data, so they can't have property mismatches. D is right since it's about Nearby's broker values versus its own spfile or runtime, not comparing between databases. Not totally sure if there's some hidden catch here though, happy for corrections.
A and D imo, B looks like a trap since it checks between databases not config vs runtime/server params.
A and D, that's it
B tbh
Be respectful. No spam.
