nerdexam
Oracle

1Z0-147 · Question #4

The upd_player, upd_player_stat, and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable?

The correct answer is A. in the package body. See the full explanation below for the reasoning.

Question

The upd_player, upd_player_stat, and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable?

Options

  • Ain the package body
  • Bin a database trigger
  • Cin the package specification
  • Din each procedure's DECLARE section, using the exact same name in each

How the community answered

(33 responses)
  • A
    70% (23)
  • B
    18% (6)
  • C
    9% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice