Oracle

1Z0-144 · Question #91

Examine the following package specification: Which statement is true?

The correct answer is A. g_comm has a value of 15 at 9: 06 AM only for Jones. Package variable state is scoped at the session level. So the only user who can see G_COMM=15 will be Jones

Creating Packages

Question

Examine the following package specification:

Which statement is true?

Exhibit

1Z0-144 question #91 exhibit

Options

Ag_comm has a value of 15 at 9: 06 AM only for Jones
Bg_comm has a value of 10 at 9: 03 AM for both Jones and smith
Cg_comm has a value of 15 at 9: 03 AM for both Jones and smith
Dg_comm has a value of 20 at 9: 06 AM for both Jones and smith

How the community answered

(58 responses)

A
84% (49)
B
10% (6)
C
3% (2)
D
2% (1)

Explanation

Package variable state is scoped at the session level. So the only user who can see G_COMM=15 will be Jones

Topics

#package state#global variables#session scope#package variables

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-144 Practice