Oracle
1Z0-481 · Question #26
Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?
The correct answer is A. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be. See the full explanation below for the reasoning.
Question
Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?
Options
- AThe first unique key alpha-numerically, excluding virtual columns and nullable columns, will be
- BThis configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.
- CThe first column, excluding virtual columns and nullable columns, will be treated as the pr key.
- DThe combination of all fields up to the first thirty-two will be treated as a compound primary key
How the community answered
(27 responses)- A81% (22)
- B4% (1)
- C11% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.