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.
A, C.
A:
PL/Scope stores the data that it collects in the SYSAUX tablespace. If the SYSAUX tablespace is unavailable, and you compile a program unit with PLSCOPE_SETTINGS=’IDENTIFIERS:ALL’, PL/Scope does not collect data for the compiled object. The compiler does not issue a warning, but it saves a warning in USER_ERRORS.
C:
Identifiers declared in compilation units that were not compiled with PLSCOPE_SETTINGS=’IDENTIFIERS:ALL’ do not appear in *_IDENTIFIER static data dictionary views.
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_plscope.htm#ADFNS022
A , C