Practice exercise

1. Identify the nature of the program which is best suited for the interpreted mode of compilation.

   1. The program unit contains multiple SQL statements.

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

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

   4. The program unit is in production phase.

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

   1. The compilation method uses C compiler to convert the program into the 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 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.

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

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

   2. The optimizer would...