IBM
C2090-320 · Question #108
When a stored procedure returns a result set to the calling program, which of the following statements is true about the two programs?
The correct answer is D. The OPEN statement is coded in the stored procedure and the FETCH statement is coded in the. See the full explanation below for the reasoning.
Question
When a stored procedure returns a result set to the calling program, which of the following statements is true about the two programs?
Options
- AThe OPEN and FETCH statements are both coded in the calling program
- BThe OPEN and FETCH statements are both coded in the stored procedure
- CThe OPEN statement is coded in the calling program and the FETCH statement is coded in the
- DThe OPEN statement is coded in the stored procedure and the FETCH statement is coded in the
How the community answered
(41 responses)- A10% (4)
- B2% (1)
- C5% (2)
- D83% (34)
Community Discussion
No community discussion yet for this question.