1Z0-076: Oracle Database 19c: Data Guard AdministrationDemo

By Oracle · Question Mode

QuestionQ11

Managing the Redo Transport Services

Examine the command that creates a database service:

Question Image

What is the significance of the COMMIT_OUTCOME attribute in this command?

  • A It ensures that all committed transactions are written to the primary database before a switchover can complete.
  • B It ensures that there is no lag while performing a switchover or a failover.
  • C It ensures that all committed transactions affected during a switchover are rolled back.
  • D It ensures that commit state for a transaction is retained after a recoverable outage.
Explanation

With COMMIT_OUTCOME set to TRUE, Oracle Transaction Guard retains a transaction’s commit outcome so that, after a recoverable outage, an application can determine whether the transaction committed. The configured RETENTION value specifies how long that outcome is retained.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!