MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The package specification is the interface to the package. |
| A. | Yes |
| B. | No |
| C. | Can be yes or no |
| D. | Can not say |
| E. | |
| Answer» B. No | |
| 2. |
The parameters can be passed as default also to the procedures and the functions. |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 3. |
Any subprogram not in the package specification but coded in the package body is called a _________ object. |
| A. | protected |
| B. | private |
| C. | self |
| D. | public |
| Answer» C. self | |
| 4. |
Packages are schema objects that groups logically related PL/SQL types, variables, and subprograms. |
| A. | Yes |
| B. | No |
| C. | Can be yes or no |
| D. | Can not say |
| Answer» B. No | |
| 5. |
The __________ Statement is used for creating the package body. |
| A. | CREATE |
| B. | CREATE PACKAGE |
| C. | CREATE BODY |
| D. | CREATE PACKAGE BODY |
| Answer» E. | |
| 6. |
All objects placed in the specification are called __________ objects. |
| A. | private |
| B. | protected |
| C. | public |
| D. | None of the above |
| Answer» D. None of the above | |
| 7. |
How many mandatory parts packages has? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |