Interview questions

SQL Server interview questions – page 5

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

  1. What is the difference between SQL and SQL Server?

  2. Wat is the main diff between sql server 2000and sql server 2005

  3. How to Handle the exceptions in Sqlsrver2000

  4. What is the default isolation level of the sql server database?

  5. Difference between Include, Forward and sendRedirect in Servlet?

  6. How send email from database?.

  7. HOW TO DELETE THE SINGLE QUOTATION IN THE SOURSE TO LOAD THE DATA TO DESTINATION

  8. If i have one transaction say mainTransaction, within thismainTransaction i have another two transaction say t1 and t2.Now while execution t1 completes successfully and commitstatement fires, but while executing t2 some error occursand rollback statement fires. What happen to t1, is it rollback or not?

  9. How to check whether some services are running in anotherserver or not? Suppose i am currently in a server named A.I want to checkwhether some services are running in server B withoutlogging into the server B.

  10. What is sql override?what is the use of it?

  11. How to replace double quotes by single quotes in sql server

  12. How to Handle the exceptions in Sqlsrver 2005?

  14. How to run a servlet program?

  15. What is referential integrity? What are the advantages of it?

  16. What is the difference between DTS and SSIS?

  17. How can we do ETL process in SQL Server?

  18. What is the uses of cursor

  19. What are the advantages of using sql server over ms access or why should one use sql instead of ms access

  20. What are cursors? Name four types of cursors and when eachone would be applied?

  21. Store procedure will return a value?

  22. How to link up the text file to a Database table?

  23. What are the magic tables in SQL Server 2000?

  24. PC(code, model, speed, ram, hd, cd, price)Find the hard drive sizes that are equal among two or more PCs.

  25. What are connection strings?

  27. Regarding joins what are the differences you observed inoracle 9i and sql server?

  28. What are the main differences between ms access and sqlserver

  29. A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

  30. Can we call stored Procedure in Function in Sql Server 2000and vice versa.

  31. How do u connect ado.net to sql server

  32. What is session ?how sessions are handeled in application?write the clauses of sql server in their order.

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