nerdexam
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)
  • A
    10% (4)
  • B
    2% (1)
  • C
    5% (2)
  • D
    83% (34)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice