JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Firm
User Defined Functions interview questions
User Defined Functions interview questions
Back
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
If the function specifies a user-defined type, requires READ permission on the type
Similar Interview Questions
Search for latest jobs
Find Jobs