SQL Server interview questions part 15
SQL Server interview questions part 15
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following is event logged by the Integration Services Service ?
Correct Answer is : SQLISService_256
2. Purpose of SQLISPackage_12546 event in SQLIS package is to :
Correct Answer is : Indicate that a task or other executable in a package has finished its work
3. A basic package in SSIS includes the following elements
Correct Answer is : Control flow elements
4. Which of the following evaluation operation is provided in SSIS ?
Correct Answer is : All of the mentioned
5. When was the first version of Microsoft SQL Server released ?
Correct Answer is : 1988
6. Which of the following companies originally worked together to create and market the first version of SQL Server?
Correct Answer is : All of the Mentioned
7. Which of the SQL Server RTM included native support for managing XML data ?
Correct Answer is : 9
8. Codename for SQL Server 2012 is __________
Correct Answer is : Denali
9. SQL Server 2005 has following features
Correct Answer is : Dynamic Management Views
10. _________ is a software application first launched with the Microsoft SQL Server 2005.
Correct Answer is : SQL Server Management Studio
11. LocalDB was introduced in which of the following versions of SQL Server ?
Correct Answer is : 2012
12. _________ is free database software running free SQL Server technology.
Correct Answer is : SQL Server Express
13. __________is the first true GUI-based database server.
Correct Answer is : SQL Server 7.0
14. Which was the first version of SQL Server to introduce in-memory capability ?
Correct Answer is : SQL Server 2014
15. What type of join is needed when you wish to return rows that do have matching values?
Correct Answer is : All of the Mentioned
16. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?
Correct Answer is : Equi-join
17. A UNION query is which of the following?
Correct Answer is : Combines the output from multiple queries and must include the same number of columns
18. Which of the following statements is true concerning subqueries?
Correct Answer is : Involves the use of an inner and outer query
19. Which of the following is a correlated subquery?
Correct Answer is : Uses the result of an inner query to determine the processing of an outer query
20. How many tables may be included with a join?
Correct Answer is : All of the Mentioned
