nerdexam
Oracle

1Z0-539 · Question #52

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

(38 responses)
  • A
    11% (4)
  • B
    82% (31)
  • C
    3% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-539 Practice