PostgreSQL_CE
PGCES-02 · Question #120
A sequence has the following definition: CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the value that is returned by executing the following SQL. SELECT nextval('seq1');
The correct answer is B. 1. See the full explanation below for the reasoning.
Question
A sequence has the following definition:
CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the value that is returned by executing the following SQL. SELECT nextval('seq1');
Options
- A0
- B1
- C10
- D11
- E-10
How the community answered
(25 responses)- A4% (1)
- B80% (20)
- D12% (3)
- E4% (1)
Community Discussion
No community discussion yet for this question.