nerdexam
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)
  • A
    81% (22)
  • B
    4% (1)
  • C
    11% (3)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-481 Practice