Practice exercise

• Which of the following dictionary views is used to get information about subprogram arguments?
  1. ALL_OBJECTS
  2. ALL_ARGUMENTS
  3. ALL_DEPENDENCIES
  4. ALL_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:

  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 that are created in the session.
  4. The identifier information would not be captured by PL/Scope since the SYSAUX tablespace is not available.
• The parameters specified in DBMS_METADATA are...