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)- A11% (4)
- B82% (31)
- C3% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.