Oracle Exam 1Z0-076 Topic 2 Question 15 Discussion

After a successful failover to the 'cats' database in a Data Guard configuration:

B: Sheep, being another standby database, would typically remain in the enabled state unless specifically disabled or if there was a configuration issue.

D: Dogs, which was the primary database prior to failover, will be in a disabled state as part of the failover process. Manual intervention is required to re-establish 'dogs' as a standby database or to return it to the primary role through another role transition.

E: If the configuration was in Maximum Availability mode before failover, it would remain in this mode after failover, provided all settings were properly configured and no changes were made to the protection mode.

Option A is incorrect because failover does not automatically change the protection mode to Maximum Performance. The protection mode remains as it was prior to the failover unless manually altered.