Name three types of PL/SQL modules. Describe each module with one characteristic specific to the module.
What will be an ideal response?
Procedure – A named block that can perform one or more tasks. It uses IN, OUT and IN OUT papameters to pass values back and forth. It can be executed as a standalone program with EXECUTE statement. Function – A named block that normally performs one task and returns a value to the calling block. It uses IN parameters. It cannot be executed as a standalone program. Package – A collection of private and public PL/SQL objects such as scalar and
composite variables, constants, exceptions, cursors, records, tables, functions and
procedures. It has specification and body.
You might also like to view...
Which of the following refers to the amount of fine detail that is visible in an image?
A) tint B) resolution C) pixels D) contrast
Match the following JavaScript terms to the descriptions
I. Arguments A. First line of a function that provides its name II. Signature B. Setting aside named memory space for a data element III. Declaration C. An interactive element displayed on a Web page. IV. Control Object D. A JavaScript keyword that refers to the current object V. This E. Another name for function parameters
Voice over Internet Protocol (VoIP) is a protocol that uses the network infrastructure in a facility for internal calls and __________ for calls outside the facility
a. The Internet b. Cell towers c. Satellites d. None of the above
A router is an internetworking device, primarily software driven, which directs traffic between two different types of LANs or two network segments with different protocol addresses.
Answer the following statement true (T) or false (F)