View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green. Examine the following sequence of commands issued by SCOTT: What is the…

The correct answer is A. SCOTT'S session displays 5, and then 0, greets session displays 0. When the call to the server ends, the memory is returned to the pool. Each time the package is reused, its public variables are initialized to their default values or to NULL. every execute is a new server call, thus

Configuring JDBC Data Sources

Question

View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green. Examine the following sequence of commands issued by SCOTT:

What is the outcome?

Exhibits

Options

ASCOTT'S session displays 5, and then 0, greets session displays 0.
BSCOTT'S session displays 5, and then 0; green's session displays 5.
CSCOTT'S session displays 5, and then 5 again, green's session displays 0.
DSCOTT'S session displays 5, and then 5 again; green's session displays 5.

How the community answered

(18 responses)

A
83% (15)
B
6% (1)
D
11% (2)

Explanation

When the call to the server ends, the memory is returned to the pool. Each time the package is reused, its public variables are initialized to their default values or to NULL. every execute is a new server call, thus

Topics

#package variables#session scope#execute privilege#package state

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice