PostgreSQL_CE
PGCES-02 · Question #81
Select two suitable statements about sequences.
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
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.
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.