MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 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. |
In mixed notation, you can mix both notations (Positional Notation and Named Notation) in procedure call. |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| E. | |
| Answer» B. FALSE | |
| 2. |
Actual parameters can be passed in ________ ways. |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 3. |
AnIN OUTparameter passes an initial value to a subprogram and returns an updated value to the caller. |
| A. | Yes |
| B. | No |
| C. | Can be yes or no |
| D. | Can not say |
| Answer» B. No | |
| 4. |
An ______ parameter lets you pass a value to the subprogram. |
| A. | IN |
| B. | OUT |
| C. | IN OUT |
| D. | None of the above |
| Answer» B. OUT | |
| 5. |
A standalone procedure is deleted with the ________ statement |
| A. | REMOVE PROCEDURE |
| B. | DELETE PROCEDURE |
| C. | Both A and B |
| D. | DROP PROCEDURE |
| Answer» E. | |
| 6. |
A standalone procedure can be called in ______ ways. |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 7. |
A procedure is created with the __________ statement. |
| A. | CREATE PROCEDURE |
| B. | REPLACE PROCEDURE |
| C. | Both A and B |
| D. | None of the above |
| Answer» D. None of the above | |
| 8. |
Which of the following is mandatory part in procedure? |
| A. | Declarative Part |
| B. | Exception-handling |
| C. | Executable Part |
| D. | All of the above |
| Answer» D. All of the above | |
| 9. |
Subprograms that do not return a value directly known as? |
| A. | Functions |
| B. | Procedures |
| C. | Triggers |
| D. | None of the above |
| Answer» C. Triggers | |
| 10. |
A __________ is a program unit/module that performs a particular task. |
| A. | procedure |
| B. | subprogram |
| C. | program |
| D. | trigger |
| Answer» C. program | |