Interview questions

SQL Server interview questions – page 9

277 questions. Tap “Show answer” to check yourself.

  1. What is BCP? When does it used?

  2. What is data integrity? Explain constraints?

  3. What are primary keys and foreign keys?

  4. What is sp_configure commands and set commands?

  5. What is the difference between a local and a global variable?

  6. What is log shipping?

  7. What is Raiseerror?

  8. What is SQL server agent?

  9. What is User Defined Functions?

  10. What is sub-query? Explain properties of sub-query.

  11. What types of Joins are possible with Sql Server?

  12. When is the use of UPDATE_STATISTICS command?

  14. Difference between Function and Stored Procedure?

  15. What is difference between DELETE & TRUNCATE commands?

  16. What is a NOLOCK?

  17. What is BCP? When do we use it?

  18. What are the authentication modes in SQL Server?

  19. What are the OS services that the SQL Server installation adds?

  20. Which stored procedure will you be running to add a linked server?

  21. Can you link only other SQL Servers or any database servers such as Oracle?

  22. What is a Linked Server?

  23. When do you use SQL Profiler?

  24. Can you explain the types of Joins that we can have with Sql Server?

  25. What is a Join in SQL Server?

  27. What do you mean by COLLATION?

  28. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

  29. What command do we use to rename a db?

  30. What is the use of DBCC commands?

  31. Can we use Truncate command on a table which is referenced by FOREIGN KEY?

  32. Can you tell me the difference between DELETE & TRUNCATE commands?

Companies that ask SQL Server questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide