SQL Server interview questions part 11
SQL Server interview questions part 11
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following SQL syntax elements is dictated by the SQL dialect levels ?
Correct Answer is : None of the mentioned
2. Which of the following function will be preferred for faster execution in following code ? SELECT RemoteOrders.* FROM ________(Northwinds, "select * from orders") RemoteOrders LEFT JOIN MasterOrders ON RemoteOrders.OrderId = MasterOrders.OrderId WHERE MasterOrders.OrderID = NULL
Correct Answer is : OpenQuery
3. .The easiest way to start is to create a linked server ‘localhost’ by using :
Correct Answer is : sp_addlinkedserver ‘localhost’
4. Trigger is special type of __________ procedure.
Correct Answer is : Stored
5. Point out the correct statement :
Correct Answer is : Triggers are database object
6. How many types of triggers are present in SQL Server ?
Correct Answer is : 4
7. How many types of DML triggers are present in SQL Server ?
Correct Answer is : None of of the mentioned
8. AFTER trigger in SQL Server can be applied to :
Correct Answer is : Table and Views
9. DML triggers in SQL Server is applicable to :
Correct Answer is : All of the mentioned
10. Triggers created with FOR or AFTER keywords is :
Correct Answer is : AFTER
11. Which of the following is not a typical trigger action ?
Correct Answer is : Select
12. Triggers can be enabled or disabled with the ________ statement.
Correct Answer is : ALTER TABLE statement
13. Which of the following is way to build dynamic sql statements ?
Correct Answer is : All of the mentioned
14. Point out the correct statement :
Correct Answer is : The SQL code is not stored in the source program, but rather it is generated based on user input
15. Dynamic SQL Statements in SQL Server can be easily built using :
Correct Answer is : Stored procedure
16. The calling syntax for sp_executesql is as follows:
Correct Answer is : sp_executesql <@stmt> [<@param1 data_type>,<@param2 data_type>, …].
17. Point out the wrong statement :
Correct Answer is : The input type @Type is passed as the first parameter to sp_executesql
18. Below Code is procedure for dynamic SQL using ___________ parameter. CREATE PROCEDURE GetArticle @ArticleID INT AS SELECT ArticleTitle, ArticleBody FROM Articles WHERE ArticleID = @ArticleID GO -
Correct Answer is : input
19. The Dynamic SQL Queries in a variable are __________ until they are executed.
Correct Answer is : All of the mentioned
20. The basic syntax for using EXECUTE command:
Correct Answer is : EXECUTE(@SQLStatement)
