nerdexam
PostgreSQL_CE

PGCES-02 · Question #15

You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction. Select one…

The correct answer is B. SCROLL CURSOR WITH HOLD. See the full explanation below for the reasoning.

Question

You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction. Select one answer containing the correct keyword(s) to fill in the underlined blank below. DECLARE cursor1 __________ FOR SELECT * FROM customer;

Options

  • ACURSOR
  • BSCROLL CURSOR WITH HOLD
  • CINSENSITIVE CURSOR
  • DNO SCROLL CURSOR WITH HOLD
  • ECURSOR WITHOUT HOLD

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    80% (20)
  • D
    4% (1)
  • E
    8% (2)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice