Oracle Advanced PL/SQL Developer Professional Guide

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