SQL Server interview questions part 30
SQL Server interview questions part 30
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. _____________ procedure cannot be created in Resource database.
Correct Answer is : User defined
2. Nesting level of stored procedure is applicable for :
Correct Answer is : All of the mentioned
3. Nesting level of a stored procedures execution is stored in the _________ function.
Correct Answer is : @@NESTLEVEL
4. Reasons for consideration of stored procedure can be :
Correct Answer is : All of the mentioned
5. Reasons for consideration of stored procedure can be :
Correct Answer is : All of the mentioned
6. Point out the correct statement :
Correct Answer is : Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed
7. Point out the correct statement :
Correct Answer is : Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed
8. __________ takes no parameters and returns all kinds of interesting information.
Correct Answer is : sp_monitor
9. __________ takes no parameters and returns all kinds of interesting information.
Correct Answer is : sp_monitor
10. Which of the following has support for transaction ?
Correct Answer is : sp_bindsession
11. Which of the following has support for transaction ?
Correct Answer is : sp_bindsession
12. Point out the wrong statement :
Correct Answer is : BASE support
13. Point out the wrong statement :
Correct Answer is : BASE support
14. __________create the removable database.
Correct Answer is : sp_certify_removable
15. __________create the removable database.
Correct Answer is : sp_certify_removable
16. Which of the following stored procedure is used for error messages ?
Correct Answer is : sp_addmessage
17. Which of the following stored procedure is used for error messages ?
Correct Answer is : sp_addmessage
18. _____________ sets procedure options in SQL Server.
Correct Answer is : sp_procoption
19. _____________ sets procedure options in SQL Server.
Correct Answer is : sp_procoption
20. __________ is used to build the code dynamically and execute it.
Correct Answer is : sp_executesql
