Interview questions

SQL Server interview questions – page 4

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

  1. What is an Index ?

  2. What is a Trigger ?

  3. What is the difference between a stored procedure and a userdefined function in sql server?

  4. How to delete duplicate rows in sql server2005

  5. Rate yourself in .net and sql database?

  6. How get current date in SQL server 2000

  7. Explain what are db_options used for?

  8. What is CTE in sql server 2005?

  9. What are the different types of backup avaible in SQL Server

  10. I have created ODBC through Data sources and tests completed sucessfully.when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0.it is given following error-message .Error: ORA-03121: NO interface driver connected- function not performed.

  11. What is difference between TRUNCATE & DELETE?

  12. Difference between sql server2000 and sql server2005

  14. What is normalization and its forms?

  15. What is the datatype returned by count(*)

  16. Which one is faster execute reader, scalar, execute non query ?

  17. What is referential integrity and how is it achieved?

  18. What are the steps you will take, if you are tasked with securing an SQL Server?

  19. Select names starts with a,b,c

  20. How to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

  21. What are constraints? Explain different types of constraints?

  22. Can we rewrite subqueries into simple select statements orwith joins? Example?

  23. What is the Magic Tables in Sqlserver2000?

  24. Can Somebody tell me the difference between Clustered & Non-Clustered Index?

  25. How to insert more than one record using insert?

  27. What is database replicaion? What are the different types of replication you can set up in SQL Server?

  28. What is Files and Filegroups in SQL Server & it's implementation.

  29. If we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

  30. Write down the code for "how we delete a table without using of Drop command " ?

  31. How many no of arguments can be passed in procedures andfunctions

  32. How many types of local tables in SQL SERVER

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