PostgreSQL Exam PGCES-02 Topic 1 Question 78 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 78
Topic #: 1

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');

C10

D11

E-10

Show Suggested Answer

Suggested Answer: A, C

by Jacquelyne at Dec 07, 2024, 01:56 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Julene

1 days ago

Hmm, that makes sense too. I guess we'll have to wait and see what the correct answer is.

upvoted 0 times

...

Jeanice

2 days ago

I disagree, I believe the answer is B) 1 because the sequence starts at 0 and the first value returned is 1.

upvoted 0 times

...

Julene

3 days ago

I think the answer is A) 0 because the sequence starts at 0 and cycles after reaching the maximum value.

upvoted 0 times

...