MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
_____________CURSOR_IS_SENSITIVE_TO_ANY_CHANGES_TO_THE_DATA_SOURCE.?$ |
| A. | Static Cursors |
| B. | Dynamic Cursors |
| C. | Keyset Driven Cursors |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 2. |
SQL_Server_static_cursors_are_always____________$ |
| A. | Read-only |
| B. | Write-only |
| C. | Read,Write |
| D. | None of the mentioned |
| Answer» B. Write-only | |
| 3. |
Which of the following FORWARD ONLY Cursor is populated at the time of creation ? |
| A. | KEYSET |
| B. | FORWARD_ONLY STATIC |
| C. | FAST_FORWARD |
| D. | All of the mentioned |
| Answer» C. FAST_FORWARD | |
| 4. |
Which of the cursors further have their subtypes ? |
| A. | Static Cursors |
| B. | Dynamic Cursors |
| C. | Keyset Driven Cursors |
| D. | None of the mentioned |
| Answer» E. | |
| 5. |
A dynamic cursor in SQL Server allows you to see __________ data. |
| A. | Updated |
| B. | Inserted |
| C. | Deleted |
| D. | All of the mentioned |
| Answer» E. | |
| 6. |
Various alternatives to cursor in SQL Server are : |
| A. | FOR |
| B. | IF..ELSE |
| C. | WHILE |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 7. |
How many type of cursor is present in SQL Server ? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» C. 5 | |
| 8. |
Life cycle of typical cursor involves ______ steps in SQL Server. |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» E. | |