Interview questions

SQL Server interview questions

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

  1. What is Stored procedure ?

  2. How will you update multiple records in a single shot? From an ASP.net appli to SQL Serevr

  3. What's the difference in HTML AJAX, ASP.Net AJAX?

  4. What are the common problems (errors) you get while implementing AJAX?

  5. What is DYNAMIC SQL method ?

  6. In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

  7. What is an Exception ? What are types of Exception ?

  8. How a sql server is been used in our programs?

  9. What is Normalization ?

  10. Explain Normalization and Denormalization with examples.

  11. What does the Log Reader agent in SQL Server 2005 replication do?

  12. What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?

  14. What magic tableWhat happen when we run any command or stored procedure is it compile ?

  15. What is the use of database index (apart from fast searching of records);What is use of composite key ?

  16. How to replace particular string.For example:- suppose their are 1000 of records for email-id.like tarun.it@hotmail.com..but i want to replace the only hotmail.com for all email-ids not the user name(tarun.it) with yahoo.com.

  17. What is table in SQL server? What is ##table in SQL server?

  18. What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL.

  19. How we can make sure that the SQL query does not return NULL values?

  20. What is the difference between User Identification and Authentication?

  21. Provide all the built in string function of SQL SERVER

  22. What cursor type do you use to retrieve multiple record sets?

  23. What is a VIEW? How to get script for a view?

  24. What is data base system? What is dbms? Give the difference between that and give the information about data base catalog?

  25. Explain real time situation where you would use clustered and Non-clustered Indexes?

  27. Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure

  28. What is the query used to display all tables names in SQL Server (Query analyzer)?

  29. Name of the class of sql

  30. What is Views in sql server?

  31. What is joins? What is the use? Where it is use?

  32. What's the use of SQL Profiler?

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