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