RelationalDBDesign
SiteMap
PL/SQL
Stored Objects
PL/SQL Programming
Creating Packages
«Prev
Next»
PL/SQL Objects
User Defined Functions
Correct Syntax Function
Syntax of Function
Stored Function
Function Returning Value
Returning Boolean Value
Function Syntax Returning Boolean
PL/SQL Blocks Conclusion
Create Function
Create Procedure
Oracle Function Procedure
Procedure Percentage Average
Procedures Calling Functions
Adding Procedure Function
Functions Procedures C onclusion
Create Trigger
What is a trigger?
Trigger Procedure Distinction
Special Trigger Variables
Combination Insert, Update, Delete
Database Triggers Conclusion
Using Parameters
PL/SQL Parameter Uses
Sending Parameters SQL*Plus
PL/SQL Parameter Usage
Parameter Procedure Placement
Return Command Function
PL/SQL Cursor Parameters
SQL*Plus Conclusion
Create Oracle Package
What is a Package?
How Packages are Used
Making Package Specification
Making Package Body
Executing Package Components
Package Conclusion
Controlling Transactions
Oracle Package Concepts - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
What are the two main components of a package?
Please select the best answer.
A.
Procedure and body
B.
Specification and body
C.
Body and declaration
D.
Private and public
2.
Which items can be contained in the package specification?
Please select all the correct answers.
A.
A private function name
B.
A public procedure name
C.
Parameters of a function
D.
Cursor declaration
3.
Which of these are an advantage of using a package compared with using stand-alone procedures and functions?
Please select all the correct answers.
A.
Ability to group related procedures and functions together
B.
Simplicity of coding structure
C.
Capability to hide functionality
D.
Ability to define IN and OUT parameters
4.
Which of these would be most appropriate use for a private procedure?
Please select the best answer.
A.
A procedure shared among multiple applications during the design phase
B.
A procedure containing calls to other private procedures
C.
A procedure accessible only inside the package body
D.
A procedure with calls to another package