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

Get Advanced Oracle PL/SQL Developer's Guide - Second Edition 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