Free C2090-730 Web TestEngine Demo

Exit VCEDump C2090-730 DB2 9 Family Fundamentals

Q25 Single choice

Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

A
DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
B
When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
C
When inserting a row in TABLE2, DB2 will only allow foreign values forIDCOL2, that is values which do not exist in IDCOL1.
D
When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

Previous Check answer

Question map25 / 46

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46

Current Correct Answered Incorrectly Reviewed 0 Remaining 46

Marked Questions0

No marked questions.

Answered Incorrectly0

No incorrect answers.

C2090-730 Web TestEngine demo