nerdexam
IBM

C2090-619 · Question #74

The DBA wants to define a replicate as follows: Which condition must be true for the command to execute successfully?

The correct answer is D. The table table1 should have an unique index on column col2. See the full explanation below for the reasoning.

Question

The DBA wants to define a replicate as follows:

Which condition must be true for the command to execute successfully?

Options

  • AThe table table1 should have col1 as its primary key.
  • BThe table table1 should have CRCOLS shadow columns.
  • CThe table table1 should have a constraint on column col1.
  • DThe table table1 should have an unique index on column col2.

How the community answered

(31 responses)
  • A
    3% (1)
  • B
    13% (4)
  • C
    6% (2)
  • D
    77% (24)

Community Discussion

No community discussion yet for this question.

Full C2090-619 Practice