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 ?

A. User-defined functions cannot call a stored procedure, but can call an extended stored procedure

B. User-defined functions cannot make use of dynamic SQL or temp tables. Table variables are allowed

C. SET statements are allowed in a user-defined function

D. The FOR XML clause is not allowed

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

2. Point out the correct statement :

A. User-defined functions cannot be used to perform actions that modify the database state

B. User-defined functions cannot contain an OUTPUT INTO clause that has a table as its target

C. User-defined functions can not return multiple result sets. Use a stored procedure if you need to return multiple result sets

D. All of the mentioned

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 ?

A. GET CONVERSATION GROUP

B. MOVE CONVERSATION

C. RECEIVE

D. All of the mentioned

Correct Answer is : All of the mentioned

4. CREATE FUNCTION requires __________ permission in the database.

A. ALTER

B. DROP

C. DELETE

D. All of the mentioned

Correct Answer is : ALTER

5. Point out the wrong statement :

A. If the function specifies a user-defined type, requires EXECUTE permission on the type

B. If the function specifies a user-defined type, requires READ permission on the type

C. If the function specifies a user-defined type, requires ALTER permission on the type

D. None of the mentioned

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

User Defined Functions interview questions