nerdexam
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)
  • A
    4% (1)
  • B
    80% (20)
  • D
    12% (3)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice