SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

What happens when rows are found using a FETCH statement?

SQL Interview Question
SQL Interview Question

Answer:

1. It causes the cursor to close
2. It causes the cursor to open
3. It loads the current row values into variables
4. It creates the variables to hold the current row values

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?Read the following code and explain: