Select two suitable statements about sequences.

The correct answer is B. A sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'. E. A sequence number can be set by calling the "setval" function. See the full explanation below for the reasoning.

Question

Options

AA sequence always returns a 4-byte INTEGER type value, so the maximum value is
BA sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'.
CAlthough the "nextval" function is called during a transaction, it will have no effect if that
DA sequence always generates 0 or consecutive positive numbers.
EA sequence number can be set by calling the "setval" function.

How the community answered

(62 responses)

A
3% (2)
B
77% (48)
C
13% (8)
D
6% (4)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice