| Snaprecruit.com

| Snaprecruit.com

Interview question based on skill :

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following is not a limitation of user defined function ?

Correct Answer is : SET statements are allowed in a user-defined function

2. Point out the correct statement :

Correct Answer is : All of the mentioned

3. Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?

Correct Answer is : All of the mentioned

4. CREATE FUNCTION requires __________ permission in the database.

Correct Answer is : ALTER

5. Point out the wrong statement :

Correct Answer is : If the function specifies a user-defined type, requires READ permission on the type