Practice exercise

• Identify the nature of the program that is best suited for the interpreted mode of compilation.

  1. The program unit contains multiple SQL statements.

  2. The program unit has just been developed and is in the debug stage.

  3. The program unit uses collections and bulk bind statements.

  4. The program unit is in the production phase.

• Choose the correct statements about the real native compilation mode in Oracle 11g.

  1. The compilation method uses the C compiler to convert the program into an equivalent C code.

  2. The compilation method mounts the shared libraries through the PLSQL_NATIVE_LIBRARY_DIR and PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT parameters.

  3. The compilation does not use the C compiler but converts the program unit directly to the M code.

  4. The real native compilation is supported for RAC environments and participates in the backup recovery processes.

• Determine the behavior of the PLSQL_OPTIMIZE_LEVEL optimizer when it has been set to 3.

  1. The optimizer would inline the programs that are necessary.

  2. The...