Interview questions

SQL Server interview questions – page 3

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

  1. Explain about Dead-locks in Sql Server database

  2. What does the Queue Reader Agent do in SQL Server 2005 replication?

  3. In which order do you perform an upgrade to SQL Server 2005 for replicated databases?

  4. What is the difference between "procedure" and "function"?

  5. Error severity 13 indicates what?

  6. What is the difference between sql server,database server and oracle server?

  7. What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.

  8. What is XMLA in SQL Server 2005

  9. When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?

  10. What is the difference between "translate" and "replace"?

  11. What is the recommended way to send mail from SQLAgent in SQL Server 2005?

  12. How do I submit a form or a part of a form without a page refresh?

  14. How can i install a sql server software in a pc?

  15. How to run SQL script from a Unix Shell?

  16. What is the difference among "dropping a table?,? truncating a table" and deleting all records" from a table.

  17. What are the new enhancements in SQL server 2005?

  18. How to find out duplicate records in sql server.

  19. Why can a "group by" or "order by" clause be expensive to process?

  20. What does this return? declare @i intselect @i = -5select +@i

  21. How does a differential backup know which extents have changed so that it can be very quickly run?

  22. What are "HINTS"? What is "index covering" of a query?

  23. Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?

  24. Difference between a "where" clause and a "having" clause

  25. How many column maximum we can add in one table and how many foreign key maximum we can use in one table

  27. What is the maximum value that can be stored for a datetime field?

  28. How to display the table data in XML format using SQL Server.

  29. What is DYNAMIC SQL method 4?

  30. What is DESCRIBE command in SQL Server? What is its purpose? How to use it?

  31. What is a "transaction"? Why are they necessary?

  32. What is a stored procedure ?

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