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

Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial