C2090-730 Dumps PDF | A programmer wants to generate values

Question: 4

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?

A. Sequence
B. Table Function
C. Identity Column
D. INSTEAD OF Trigger

Answer: A

Leave a Reply

Your email address will not be published. Required fields are marked *