SQL Server interview questions part 12
SQL Server interview questions part 12
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following is a disadvantage of dynamic SQL ?
Correct Answer is : Stored procedure can not cache the execution plan for this dynamic query
2. Which of the stored procedure used for dynamic SQL is prone to attacks ?
Correct Answer is : sp_executesql
3. Which of the following blocks are used for error handling in SQL Server ?
Correct Answer is : TRY…CATCH
4. Point out the correct statement :
Correct Answer is : While executing some DML Statement like INSERT, DELETE, UPDATE we can handle the error for checking proper output
5. Which of the following statements can be checked for Errors ?
Correct Answer is : INSERT
6. Purpose of TRY…CATCH block in SQL Server is :
Correct Answer is : Error handling
7. Point out the wrong statement :
Correct Answer is : If an error occurs in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block
8. Which of the following benefit does Exception handling with the TRY and CATCH blocks provide ?
Correct Answer is : All of the mentioned
9. Exception handling is possible in SQL Server using :
Correct Answer is : THROW
10. Which of the following is a Error function used within CATCH block ?
Correct Answer is : ERROR_STATE()
11. ERROR_SEVERITY() returns the ________level of the error.
Correct Answer is : Severity
12. Which of the following is global variable for error handling ?
Correct Answer is : @@ERROR
13. Which of the following is a extended event task ?
Correct Answer is : All of the mentioned
14. Point out the correct statement :
Correct Answer is : The SQL Server Extended Events engine is a collection of services and objects
15. SQL Server Extended Events Packages consist of :
Correct Answer is : All of the mentioned
16. Which of the DDL statement creates a session object that contains the metadata ?
Correct Answer is : CREATE EVENT SESSION
17. Point out the wrong statement :
Correct Answer is : Extended Event sessions have implied boundaries in that the configuration of one session does change the configuration of another session
18. _________ can be applied to the metadata or to an active session and the metadata.
Correct Answer is : All of the mentioned
19. Which of the following catalog view is used for SQL Server Extended Events ?
Correct Answer is : sys.server_event_session_actions
20. _________ returns a row for each customizable column that was explicitly set on events and targets.
Correct Answer is : sys.server_event_session_fields
