Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two)

Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two)

Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two)

A.
It persists across transactions within a session.

B.
It persists from session to session for the same user.

C.
It does not persist across transaction within a session.

D.
It persists from user to user when the package is invoked.

E.
It does not persist from session to session for the same user.

Explanation:
You can keep track of the state of a package variable or cursor, which persists throughout the user session, from the time the user first references the variable or cursor to the time the user disconnects.
1. Initialize the variable within its declaration or within an automatic, one-time-only procedure.
2. Change the value of the variable by means of package procedures.
3. The value of the variable is released when the user disconnects.
Incorrect Answers
B: Each session will have its own value for the variables
C: It persists across the transactions and through the user session.
D: Each user has his own values and results, because each user has his own users.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jyoti

Jyoti

A and E are correct