[Solved] Given the following SQL cursor code snippet, what will be the output?DECLARE @Name VARCHAR(50); DECLARE name_cursor CURSOR FOR SELECT Name FROM Employees WHERE Department = 'Sales'; OPEN name_cursor;... | SQL

SQL - Stored Procedures and Functions

Given the following SQL cursor code snippet, what will be the output?

DECLARE @Name VARCHAR(50);
DECLARE name_cursor CURSOR FOR SELECT Name FROM Employees WHERE Department = 'Sales';
OPEN name_cursor;
FETCH NEXT FROM name_cursor INTO @Name;
WHILE @@FETCH_STATUS = 0
BEGIN
  PRINT @Name;
  FETCH NEXT FROM name_cursor INTO @Name;
END
CLOSE name_cursor;
DEALLOCATE name_cursor;

Assuming the Employees table has Sales department names: 'Alice', 'Bob', 'Carol'.

AOnly 'Alice' is printed

BSyntax error due to missing FETCH

CNo output because cursor is not opened

DAlice Bob Carol (each printed on a new line)

Step-by-Step Solution

Solution:

Step 1: Understand cursor fetch loop
The cursor fetches each row where Department = 'Sales'. It prints the @Name variable for each fetched row.
Step 2: Identify the printed names
Since the table has 'Alice', 'Bob', and 'Carol' in Sales, all three names will be printed one by one.
Final Answer:
Alice Bob Carol (each printed on a new line) -> Option D
Quick Check:
Cursor prints all fetched rows [OK]

Quick Trick: Cursor loops print all fetched rows until none left [OK]

Common Mistakes:

Assuming only first row prints
Forgetting to open cursor
Confusing fetch status check

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given the following SQL cursor code snippet, what will be the output?

Step 1: Understand cursor fetch loop

Step 2: Identify the printed names

Final Answer:

Quick Check:

Want More Practice?