nerdexam
Oracle

1Z0-481 · Question #72

You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?

The correct answer is B. None: loop detection is on by default in Oracle. See the full explanation below for the reasoning.

Question

You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?

Options

  • AInserts will generate a primary key uniqueness violation; deletes will generate a `no matching row'
  • BNone: loop detection is on by default in Oracle.
  • CNew inserts will be processed without issue; updates and deletes will generate a "row not found" error.
  • DUpdates and deletes will be replicated without issue new inserts will generate a primary key uniqueness

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    79% (19)
  • C
    8% (2)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-481 Practice