Module 12: Cursors

What is the primary purpose of using cursors in SQL?

• To combine data from multiple tables

• To manipulate table structure

• To retrieve and process rows from a result set one at a time

• To perform complex mathematical calculations

What is the purpose of the CLOSE statement in SQL cursors?

• It fetches the first row from the cursor

• It releases the resources associated with the cursor

• It restarts the cursor

• It fetches the last row from the cursor

What is a drawback of using cursors in SQL?

• They are always more efficient than set-based operations

• They can only be used for simple SELECT statements

• They might lead to performance issues and slow processing

• They cannot be used in conjunction with subqueries

What is a scenario where using a cursor could be a good choice?

• When performing aggregation on large datasets

• When performing multiple UPDATE statements in a single query

• When processing each row to apply business logic based on certain conditions

• When retrieving a large number of rows for reporting purposes

What is the purpose of the @@FETCH_STATUS variable in a cursor loop?

• It holds the number of rows fetched by the cursor

• It indicates whether a fetch operation was successful

• It keeps track of the cursor's position

• It determines the number of rows remaining in the result set