PostgreSQL_CE
PGCES-02 · Question #81
PGCES-02 Question #81: Real Exam Question with Answer & Explanation
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
Select two suitable statements about sequences.
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.
Community Discussion
No community discussion yet for this question.