MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 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. |
NESTING_LEVEL_OF_A_STORED_PROCEDURES_EXECUTION_IS_STORED_IN_THE___________FUNCTION.?$ |
| A. | @@NEST |
| B. | @@NESTLEVEL |
| C. | @@LEVEL |
| D. | None of the mentioned |
| Answer» C. @@LEVEL | |
| 2. |
Nesting level of stored procedure is applicable for ? |
| A. | Triggers |
| B. | Views |
| C. | Functions |
| D. | All of the mentioned |
| Answer» E. | |
| 3. |
_____________ procedure cannot be created in Resource database? |
| A. | System |
| B. | User defined |
| C. | Extended |
| D. | All of the mentioned |
| Answer» C. Extended | |
| 4. |
__________ provides details on any database object. |
| A. | sp_changeowner |
| B. | sp_owner |
| C. | sp_change |
| D. | None of the mentioned |
| Answer» E. | |
| 5. |
Which of the following is a system procedure ? |
| A. | sp_changeowner |
| B. | sp_owner |
| C. | sp_change |
| D. | All of the mentioned |
| Answer» B. sp_owner | |
| 6. |
Data return using output parameter is : |
| A. | Return codes, which are always an integer value |
| B. | A global cursor that can be referenced outside the stored procedure |
| C. | A single cursor that can be referenced inside the stored procedure |
| D. | None of the mentioned |
| Answer» E. | |
| 7. |
How many ways of returning data is present in SQL Server 2000 ? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» C. 5 | |