IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 29

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

Answer options

• A. Sequence
• B. Row Identifier
• C. Identity Column
• D. Insert time clustering table

Correct answer: A

Explanation

The correct answer is A, Sequence, as it is specifically designed to generate unique numeric values that can be retrieved using PREVIOUS VALUE and NEXT VALUE expressions. The other options, such as Row Identifier and Identity Column, do not provide this functionality, while Insert time clustering table refers to a different database feature.