Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL Exam PGCES-02 Topic 1 Question 78 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 78
Topic #: 1
[All PGCES-02 Questions]

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

Show Suggested Answer Hide 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
Lacresha
1 days ago
I think the correct answer is B) 1. The CACHE 10 parameter means that the sequence will pre-allocate 10 values, so the first call to nextval() should return 1.
upvoted 0 times
...
Julene
13 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
14 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
15 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
...

Save Cancel