📊 MySQL
Q. Which statements are used to control a cursor variable?
  • (A) OPEN-FOR
  • (B) FETCH
  • (C) CLOSE
  • (D) All mentioned above
💬 Discuss
✅ Correct Answer: (D) All mentioned above

Explanation: There are three statements used to control a cursor variable:
1. OPEN-FOR - open a cursor variable for multi-row query
2. FETCH - it fetches the rows for the result set
3. CLOSE - when all the rows are processed the cursor variable is closed.

Explanation by: Akshay Kulkarni
There are three statements used to control a cursor variable:
1. OPEN-FOR - open a cursor variable for multi-row query
2. FETCH - it fetches the rows for the result set
3. CLOSE - when all the rows are processed the cursor variable is closed.

💬 Discussion

📊 Question Analytics

👁️
278
Total Visits
📽️
4 y ago
Published
🎖️
Akshay Kulkarni
Publisher
📈
96%
Success Rate