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. |
TYPE_OF_PROCEDURE_THAT_ARE_BASED_ON_THE_CLR_(COMMON_LANGUAGE_RUNTIME)_IS_:?$ |
| A. | User Defined Stored Procedure |
| B. | Extended Procedure |
| C. | CLR Stored Procedure |
| D. | System defined Procedure |
| Answer» D. System defined Procedure | |
| 2. |
Nesting_limit_OF_stored_procedure_is_up_to_________level.$ |
| A. | 30 |
| B. | 32 |
| C. | 34 |
| D. | 36 |
| Answer» C. 34 | |
| 3. |
Extended procedures starts with the __________ prefix? |
| A. | sp_ |
| B. | xp_ |
| C. | clr_ |
| D. | all of the mentioned |
| Answer» B. xp_ | |
| 4. |
System defined Procedure logically appear in : |
| A. | sys schema |
| B. | stor schema |
| C. | proc schema |
| D. | all of the mentioned |
| Answer» B. stor schema | |
| 5. |
Which of the following stored procedure is already defined in Sql Server ? |
| A. | User Defined Stored Procedure |
| B. | Extended Procedure |
| C. | CLR Stored Procedure |
| D. | System defined Procedure |
| Answer» E. | |
| 6. |
Which of the following procedures are created by user for own actions ? |
| A. | User Defined Stored Procedure |
| B. | Extended Procedure |
| C. | CLR Stored Procedure |
| D. | All of the mentioned |
| Answer» B. Extended Procedure | |
| 7. |
How many types of stored procedures are present in SQL Server ? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 8 |
| Answer» C. 5 | |
| 8. |
Stored procedure is a __________ set of one or more SQL statements. |
| A. | interpreted |
| B. | compiled |
| C. | pre compiled |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |