IBM
C2090-312 · Question #34
You have to design a table and application layout, in which automatic number generation is used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which…
The correct answer is C. Identity cannot deliver this functionality, but Sequence can. See the full explanation below for the reasoning.
Question
You have to design a table and application layout, in which automatic number generation is used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?
Options
- ANeither Identity nor Sequence can deliver this functionality.
- BIdentity can deliver this functionality, but Sequence cannot.
- CIdentity cannot deliver this functionality, but Sequence can.
- DIdentity and Sequence can both deliver this functionality.
How the community answered
(37 responses)- A8% (3)
- B5% (2)
- C84% (31)
- D3% (1)
Community Discussion
No community discussion yet for this question.