ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

30 / 68

Question 30:

You execute teh following command to alert the session parameter: 
image
Which two statements are true in this scenario? (Choose two.) 

Answer options:

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 identifies 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