User Defined Functions interview questions
User Defined Functions interview questions
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
