Which two are true about database roles in an Oracle Data Guard Configuration?
A.
A configuration consisting only of a primary and one or more physical standby databases can support a
rolling release upgrade.
B.
A Logical Standby Database can be converted to a Snapshot Standby Database.
C.
A Logical Standby Database can cascade redo to a terminal destination.
D.
A Snapshot Standby Database can be a fast-start failover target.
E.
A Physical Standby Database can be converted into a Logical Standby Database.
Explanation:
B: A snapshot standby database can be converted back into a physical standby database at any time.
E: You create a logical standby database by first creating a physical standby database and then transitioning it
to a logical standby database.
Incorrect Answers:
A: Oracle Database supports the installation of database software upgrades, and the application of patch sets,
in a rolling fashion—with near zero database downtime—by using Data Guard SQL Apply and logical standby
databases.
C: A cascaded redo transport destination (also known as a terminal destination) receives primary database
redo indirectly from a standby database rather than directly from a primary database. Only physical standby
databases can cascade redo.
D: A snapshot standby cannot be the target of a switchover or fast-start failover operation.
https://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ls.htm#SBYDB4732
https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB00580
Correct Ans: A, E
A is correct: A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade by converting physical standby to transient logical standby and KEEP IDENTITY.
B is in correct as you cannot convert Logical standby to Snapshot standby. You can convert physical standby to snapshot standby as well as snapshot to physical.
Explanation:
To upgrade the database software in an Oracle Data Guard configuration in a rolling fashion, you first designate a physical standby as the future primary database. Rolling upgrade process splits the Oracle Data Guard configuration into two groups: the leading group (LG) and the trailing group (TG). The future primary is first converted into a logical standby database and then the new database software is installed on it and the upgrade process is run. Other standby databases in the leading group also must have their software upgraded at this point.
This means that the manual Transient Logical Standby upgrade procedure must still be used when upgrading from Oracle Database 11g to Oracle Database12c, or when upgrading from the initial Oracle Database 12c release to the first patchset of Oracle Database 12c.
E: A Physical standby database can be converted into a logical standby database.
Incorrect Answers:
B: You cannot convert a logical standby database to a snapshot standby database. You must convert to physical standby first.
C: A cascaded redo transport destination (also known as a terminal destination) receives primary database redo indirectly from a standby database rather than directly from a primary database. Only physical standby databases can cascade redo.
D: A snapshot standby cannot be the target of a switchover or fast-start failover operation.
https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm#SBYDB5214
A,E