Which of the following is the correct syntax to declare a cursor named cur_emp for selecting all rows from employees table?

easy📝 Syntax Q12 of 15

PostgreSQL - Advanced PL/pgSQL

Which of the following is the correct syntax to declare a cursor named cur_emp for selecting all rows from employees table?

ACREATE CURSOR cur_emp AS SELECT * FROM employees;

BOPEN cur_emp CURSOR SELECT * FROM employees;

CDECLARE cur_emp CURSOR FOR SELECT * FROM employees;

DFETCH cur_emp FROM employees;

Step-by-Step Solution

Solution:

Step 1: Recall cursor declaration syntax
In PostgreSQL, cursors are declared with DECLARE cursor_name CURSOR FOR query.
Step 2: Match syntax with options
DECLARE cur_emp CURSOR FOR SELECT * FROM employees; matches this exactly; others use incorrect keywords or order.
Final Answer:
DECLARE cur_emp CURSOR FOR SELECT * FROM employees; -> Option C
Quick Check:
DECLARE + CURSOR + FOR + query = correct syntax [OK]

Quick Trick: Use DECLARE ... CURSOR FOR ... to declare [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free