nerdexam
Oracle

1Z0-144 · Question #33

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

The correct answer is A. The SELECT list is not known until run time. C. You do not know how many columns a select statement will return, or what their data types will. See the full explanation below for the reasoning.

Question

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

Options

  • AThe SELECT list is not known until run time.
  • BThe dynamic SQL statement retrieves rows into records.
  • CYou do not know how many columns a select statement will return, or what their data types will.
  • DYou must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an

How the community answered

(22 responses)
  • A
    82% (18)
  • B
    14% (3)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-144 Practice