Which two statements are true in this scenario?

You executed the following command to alter the session parameter:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS:ALL’;
Which two statements are true in this scenario? (Choose two.)

You executed the following command to alter the session parameter:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS:ALL’;
Which two statements are true in this scenario? (Choose two.)

A.
If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not
collect data for the compiled object.

B.
All the identifiers declared in compiled program units before altering the parameter settings
appear in the *_IDENTIFIER static data dictionary views.

C.
All the identifiers declared in compiled program units before altering the parameter settings do
not appear in the *_IDENTIFIER static data dictionary views.

D.
If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects
data for the compiled object and stores it in the SYSTEM tablespace.



Leave a Reply 1

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