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. |
Explicit cursors are programmer-defined cursors for gaining more control over thecontext area. |
| A. | Yes |
| B. | No |
| C. | Can be yes or no |
| D. | Can not say |
| E. | |
| Answer» B. No | |
| 2. |
The Implicit cursors are created in order to process the ____ statements. |
| A. | DDL |
| B. | DCL |
| C. | DML |
| D. | TCL |
| Answer» D. TCL | |
| 3. |
Oracle creates ___________ when SQL statements are processed. |
| A. | Content Areas |
| B. | Context Areas |
| C. | Context Ids |
| D. | Content Ids |
| Answer» C. Context Ids | |
| 4. |
Which of the following is correct syntax to open the Cursor? |
| A. | SELECT cursor_name |
| B. | INSERT cursor_name |
| C. | UPDATE cursor_name |
| D. | OPEN cursor_name |
| Answer» E. | |
| 5. |
Which attribute returns TRUE if an INSERT, UPDATE, or DELETE statement affected one or more rows? |
| A. | %NOTFOUND |
| B. | %ISOPEN |
| C. | %ROWCOUNT |
| D. | %FOUND |
| Answer» E. | |
| 6. |
Programmers cannot control the _______ cursors and the information in it. |
| A. | implicit |
| B. | explicit |
| C. | both a and b |
| D. | Can not say |
| Answer» B. explicit | |
| 7. |
How many types of cursors? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 8. |
The set of rows the cursor holds is referred to as the __________. |
| A. | inactive set |
| B. | simple set |
| C. | active set |
| D. | complex set |
| Answer» D. complex set | |
| 9. |
PL/SQL controls the context area through a cursor. |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 10. |
A _____ is a pointer to this context area. |
| A. | records |
| B. | cursor |
| C. | packages |
| D. | trigger |
| Answer» C. packages | |