Which of the following statements are true about the
extproc
process?It loads the shared library of the external C program.
It is started by the PL/SQL runtime engine.
It is a session specific process.
The
extproc
process compiles the C program while loading.
Oracle 7 introduced the external procedure feature for sending mails from PL/SQL.
True
False
Determine the effect of dropping the library object which has been used in a PL/SQL call specification and in use:
The PL/SQL wrapper method gets invalidated
The shared library gets corrupted
The PL/SQL wrapper method still works fine as it has been already executed once
The PL/SQL wrapper method gives no output
Examine the following
TNSNAMES.ora
andLISTENER.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...
Argentina
Australia
Austria
Belgium
Brazil
Bulgaria
Canada
Chile
Colombia
Cyprus
Czechia
Denmark
Ecuador
Egypt
Estonia
Finland
France
Germany
Great Britain
Greece
Hungary
India
Indonesia
Ireland
Italy
Japan
Latvia
Lithuania
Luxembourg
Malaysia
Malta
Mexico
Netherlands
New Zealand
Norway
Philippines
Poland
Portugal
Romania
Russia
Singapore
Slovakia
Slovenia
South Africa
South Korea
Spain
Sweden
Switzerland
Taiwan
Thailand
Turkey
Ukraine
United States