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. |
PL/SQL provides a user-defined record type that allows you to define the different record structures. |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| E. | |
| Answer» B. FALSE | |
| 2. |
A PL/SQL record can be used as an argument of parameter in a ________. |
| A. | Procedure |
| B. | Function |
| C. | Trigger |
| D. | All of the above |
| Answer» C. Trigger | |
| 3. |
To check if the record is NULL, you have to check each individual field of the record. |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 4. |
You can assign a PL/SQL record NULL value by assigning an uninitialized record. |
| A. | Yes |
| B. | No |
| C. | Can be yes or no |
| D. | Can not say |
| Answer» B. No | |
| 5. |
In how many ways to declare a record? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 6. |
__________ consist of different fields, similar to a row of a database table. |
| A. | Records |
| B. | Trigger |
| C. | Cursor |
| D. | Collection |
| Answer» B. Trigger | |
| 7. |
To access any field of a record, we use the ________ operator. |
| A. | & |
| B. | # |
| C. | $ |
| D. | . |
| Answer» E. | |
| 8. |
The %ROWTYPE attribute enables a programmer to create _______ records. |
| A. | table-based |
| B. | cursorbased |
| C. | table-basedandcursorbased |
| D. | None of the above |
| Answer» D. None of the above | |
| 9. |
Which of the following is a types of records? |
| A. | Table-based |
| B. | Cursor-based records |
| C. | User-defined records |
| D. | All of the above |
| Answer» E. | |
| 10. |
A _________ is a data structure that can hold data items of different kinds. |
| A. | trigger |
| B. | cursor |
| C. | record |
| D. | package |
| Answer» D. package | |