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. |
WHICH_OF_THE_FOLLOWING_DOES_NOT_RETURN_A_TABLE_VARIABLE??$ |
| A. | System-defined function |
| B. | Scalar Function |
| C. | Inline Table-Valued Function |
| D. | Multi-Statement Table-Valued Function |
| Answer» C. Inline Table-Valued Function | |
| 2. |
User_defined_scalar_function_can_return_only____________data_type_values.$ |
| A. | Numerical |
| B. | String |
| C. | Float |
| D. | All of the mentioned |
| Answer» E. | |
| 3. |
Which of the following is not a User defined function ? |
| A. | Max() |
| B. | Scalar Function |
| C. | Inline Table-Valued Function |
| D. | Multi-Statement Table-Valued Function |
| Answer» B. Scalar Function | |
| 4. |
How many types of user defined function is provided by SQL Server? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 5. |
Syntax for creation of user defined function is : |
| A. | CREATE FUNCTIONS |
| B. | CREATE FUNCTION |
| C. | CREATE FUNC |
| D. | All of the mentioned |
| Answer» C. CREATE FUNC | |
| 6. |
The benefit of using user-defined functions in SQL Server are: |
| A. | They allow modular programming |
| B. | They can increase network traffic |
| C. | They allow slower execution |
| D. | All of the mentioned |
| Answer» B. They can increase network traffic | |
| 7. |
Function cannot be used for __________ statement. |
| A. | Create |
| B. | Drop |
| C. | Select |
| D. | Insert |
| Answer» E. | |
| 8. |
User defined function in SQL Server can return : |
| A. | Scalar value |
| B. | Set of values |
| C. | Result set |
| D. | All of the mentioned |
| Answer» E. | |