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)- A4% (1)
- B79% (19)
- C8% (2)
- D8% (2)
Community Discussion
No community discussion yet for this question.