Q: 1
You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration. The databases are all in ARCHIVELOG mode. You will execute the SQL statement: ALTER DATABASE FLASHBACK ON; Which three are true concerning this command?
Options
Discussion
ABE? I saw a similar question in the official practice test and the Oracle docs back this up, but if anyone checked the user guide recently let me know. Always good to double check with lab if possible.
B is valid, but A and E too. D is tricky-a lot of folks pick it by mistake, but flashback isn't pushed to standbys automatically. Similar question showed up in practice and the trap was thinking D or F applied. Pretty sure it's ABE.
B tbh had something like this in a mock, pretty sure it was A, B, and E.
Its ABE here. But watch out: if the physical standby is open for Real Time Query (option C), ALTER DATABASE FLASHBACK ON won’t work unless it’s mounted instead. Seen a few trick questions on that scenario, so always check the open mode.
Its ABE, since you can turn on flashback both when primary is open or mounted, plus logical standby while SQL Apply is running. You always have to enable it separately on each database though. Pretty sure about this but let me know if there's a catch I missed.
Wish Oracle would make this less confusing... B tbh. Seen similar in exam reports, and it always comes down to enabling on each DB separately. Flashback works on primary open or mounted and logical standby with SQL apply running, I think. Disagree?
Its ABE here, you need to set flashback individually per database. D and F don't happen automatically.
D imo
Be respectful. No spam.