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

Lajuana

12 days ago

This question is a real sequence-buster! I'm tempted to say E) -10, just to see the look on the examiner's face.

upvoted 0 times

...

Ciara

13 days ago

I'm going to go with A) 0. Why not? Sequences can be a bit unpredictable sometimes, so 0 seems like a good answer to throw off the competition.

upvoted 0 times

...

Elly

16 days ago

Hmm, this is tricky. I'm leaning towards C) 10, because the CACHE 10 parameter means the sequence will pre-allocate 10 values at a time.

upvoted 0 times

Nydia

1 days ago

I think it's B) 1, because the sequence starts at 1 by default.

upvoted 0 times

...

Crissy

23 days ago

My guess is D) 11. Since the sequence is set to CYCLE, it will start over from the beginning once it reaches the maximum value, so the next call should return 11.

upvoted 0 times

...

2 months ago

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

upvoted 0 times

...