Practice exercise

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

2. Oracle 7 introduced the external procedure feature for sending mails from PL/SQL.

   1. True

   2. False

3. Determine the effect of dropping the library object which has been used in a PL/SQL call specification and 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 been already executed once

   4. The PL/SQL wrapper method gives no output

4. 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.ora
   SID_LIST_LISTENER...