Practice exercise

• Which of the following statements are true about the extproc process?

  1. It loads the shared library of the external C program.

  2. It is started by the PL/SQL runtime engine.

  3. It is a session-specific process.

  4. The extproc process compiles the C program while loading.

• Oracle 7 introduced the external procedure feature for sending e-mails from PL/SQL.

  1. True

  2. False

• Determine the effect of dropping the library object that has been used in a PL/SQL call specification while it is still in use:

  1. The PL/SQL wrapper method gets invalidated.

  2. The shared library gets corrupted.

  3. The PL/SQL wrapper method still works fine as it has already been executed once.

  4. The PL/SQL wrapper method gives no output.

• Examine the following TNSNAMES.ora and LISTENER.ora entries and choose the correct option:

  //TNSNAMES.ora
  ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
        (SID = extproc)
        (PRESENTATION = RO)
      )
    )
  //LISTENER...