SQL Server interview questions part 29
SQL Server interview questions part 29
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. If xp_cmdshell has been disabled with sp_dropextendedproc, we can simply inject the following code:
Correct Answer is : sp_addextendedproc ‘xp_cmdshell’,’xp_log70.dll’
2. Which of the following script is an example of Quick detection in SQL injection attack?
Correct Answer is : For integer inputs : convert(int,@@version)
3. _______________ is time based SQL injection attack.
Correct Answer is : Blind SQL Injection
4. __________ is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2014.
Correct Answer is : Agent
5. Point out the correct statement :
Correct Answer is : All of the mentioned
6. SQL Server Agent consist of _____ component.
Correct Answer is : 3
7. SQL Agent Job definitions are specified in which database ?
Correct Answer is : msdb
8. Point out the wrong statement :
Correct Answer is : SQL Server Agent allows you to automate a variety of administrative task
9. _________start and stop the SQL Server Agent Service .
Correct Answer is : All of the mentioned
10. Which of the following condition is considered for schedule ?
Correct Answer is : All of the mentioned
11. An alert can respond to one of the following conditions :
Correct Answer is : SQL Server performance conditions
12. SQL Server can notify operators of alerts through :
Correct Answer is : All of the mentioned
13. Which of the following members has access to SQL Server Agent ?
Correct Answer is : members of the sysadmin
14. How many ways of returning data is present in SQL Server 2000 ?
Correct Answer is : 4
15. Point out the correct statement :
Correct Answer is : All of the mentioned
16. Data return using output parameter is :
Correct Answer is : None of the mentioned
17. Which of the following is a system procedure ?
Correct Answer is : sp_changeowner
18. Point out the wrong statement :
Correct Answer is : sp_helpdb provides the text of a stored procedure reside in Sql Server
19. __________ provides details on any database object.
Correct Answer is : None of the mentioned
20. Which of the following is extended procedure ?
Correct Answer is : xp_logininfo
