nerdexam
IBM

P2090-050 · Question #62

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

The correct answer is A. Using the EXECUTE command. D. Using the SELECT statement without a FROM clause. See the full explanation below for the reasoning.

Question

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

Options

  • AUsing the EXECUTE command.
  • BUsing the SELECT statement within a FROM clause.
  • CUsing the SELECT statement within a HAVING clause.
  • DUsing the SELECT statement without a FROM clause.
  • EUsing the SELECT statement with tables in the FROM clause.

How the community answered

(41 responses)
  • A
    83% (34)
  • B
    2% (1)
  • C
    10% (4)
  • E
    5% (2)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice