Practice exercise

1. Which of the following dictionary views is used to get information about the subprogram arguments?

   1. ALL_OBJECTS

   2. ALL_ARGUMENTS

   3. ALL_DEPENDENCIES

   4. ALL_PROGRAMS

2. The tablespace information on a database server:

   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:

   1. The identifier information would be captured by PL/Scope for the program created or compiled in the session.

   2. The identifier information would not be captured by PL/Scope as IDENTIFIERS:ALL can be enabled only at the SYSTEM level.

   3. The identifier information would be captured by PL/Scope only for the programs which are created in the session.

   4. The identifier information would not be captured by PL/Scope since the SYSAUX tablespace is not available.

3. The parameters specified in DBMS_METADATA are case sensitive...