Chapter 4, Using Advanced Interface Methods

Question No.

Answer

Explanation

1

a and c

The extproc process is a session specific process started by the Oracle listener and loads the shared library.

2

b

External procedure support was introduced in Oracle 8.

3

a

The PL/SQL wrapper containing the call specification is dependent on the database library object.

4

b

The TNS service ORACLR_CONNECTION_DATA connects to the listener with the SID_NAME in the CONNECT_DATA parameter.

5

b

The loadjava utility loads the Java class to a specified user in a database.

6

a

Java programs are directly supported by Oracle and do not use the extproc process.

7

c

The external function name is case sensitive. The PL/SQL wrapper must use it exactly ...

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.