No results found for the specified position. Print | 20 Sql Server Developer Interview Questions | MockQuestionsSql Server Developer Interview Questions
Go Back1. What is a linked server?
2. What is a view and how is it used?
3. How would you return the first 100 records from a table based upon the order of a numerical value?
4. Define SSIS.
5. Describe the process of replication.
6. What is a SQL Server Credential?
7. What are server roles and how are they used? Name some fixed database roles.
8. What is the function of the SQL Agent? Provide a use case and TSQL code.
9. In a SQL query, how would you perform pattern matching?
10. What is a group by clause and how would you use it?
11. In SSMS, how do you know if a query is performing a table scan?
12. What is a correlated subquery? Provide an example.
13. What is a temporary table and what is it used for?
14. What is a cursor? Provide the syntax for creating one.
15. What is a trigger and how many different types are there?
16. What is stored procedure and what is the basic syntax for creating one? How and why would you use one?
17. Describe the difference between an outer and inner join.
18. What is a cartesian product?
19. What is meant by referential integrity?
20. How do you determine which columns to add in an index and what command would you use to create it?