Practice exercise
- Which of the following dictionary views is used to get information about subprogram arguments?
ALL_OBJECTSALL_ARGUMENTSALL_DEPENDENCIESALL_PROGRAMS
- The tablespace information on a database server is as follows:
SELECT tablespace_name FROM DBA_TABLESPACES / TABLESPACE_NAME ---------------- SYSTEM UNDOTBS1 TEMP USERS EXAMPLE
You execute the following command in the session:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; Session altered.
Identify the correct statements:
- The identifier information would be captured by PL/Scope for the program created or compiled in the session.
- The identifier information would not be captured by PL/Scope as
IDENTIFIERS:ALLcan be enabled only at theSYSTEMlevel. - The identifier information would be captured by PL/Scope only for the programs that are created in the session.
- The identifier information would not be captured by PL/Scope since the
SYSAUXtablespace is not available.
- The parameters specified in
DBMS_METADATAare...
