SQL Server Interview Questions

SQL Server Interview Questions : Database

1. What is DBMS?
2. What is RDBMS?
3. What are the ACID properties?
4. What is Normalization?
5. What is D-normalization and when do we need it?
6. What are the different Normal Forms?

SQL Server Interview Questions: Table Design

1. What is Table?  *
2. What is Data type? *
3. What are the different types of data types in SQL Server? *
4. What is the difference between Float, BIG Int and Integer? *
5. Explain the Decimal Data types and its uses. *
6. What is the use of different types of Integer data types? *
7. What is the difference between bit, Char and Varchar? *
8. What is Unicode? **
9. What is the difference between Varchar and Nvarchar? **
10. What are different date time data types? *
11. What are unique identifiers in SQL Server Table? **
12. What is check constraint in SQL Server? **
13. What is default constraint? *
14. What is Null ability? *
15. Explain table relationship? *
16. What is Primary Key? *
17. What is Foreign Key? *
18. What is composite key? *
19. What are Primary Key and Foreign Key Constraint? *
20. How to get the list of primary key and foreign key of the table? ****
21. Can we insert null value in primary column? *
22. What is difference between Primary Key and Unique Key? **
23. What is Identity Column in Table? *
24. Syntax to check current Identity of the table? *
25. What is the difference between Scope of Identity on @@identity? ***
26. Can we change identity key values for a table or reset the identity key value. ***
27. What is function Ident_INCR? ***
28. What is times stamp data type is SQL Server? **
29. What is the alternative of timestamp? **

SQL Server Interview Questions: Select and joins

1. What is select statement in TSQL? *
2. What is the Join in SQL Server? *
3. What are the different types of join? *
4. Difference between Left join and Outer Join? *
5. What is left outer join and right outer join? *
6. What is full outer join? *
7. What is inner join? *
8. What is cross join? *
9. Write one example for self-join? **
10. What is where clause? *
11. What are the sub queries? *
12. What are the nested queries in SQL Server? **
13. What is inline query? **
14. What are the aggregate functions in SQL Server? *
15. What is Group By?  *
16. What is Having clause? **
17. What is difference between where and having clause? **
18. What is the table variable? **
19. What is the temporary table? **
20. What is the global temporary table? **
21. Difference between temporary table and table variable? **
22. What is the union all clause? **
23. What is union Clause? **
24. Difference between union all and union clause? **
25. What is the Ranking function in SQL Server? ****
26. Difference between rank and dense rank? ****
27. What is top operator in SQL Server? **
28. What is table sample in SQL Server? ***
29. What is the delete command? *
30. What is truncate command? **
31. Difference between delete and truncate? **
32. What are dynamic queries? ***
33. What is distinct clause? How it works? **
34. How to use Order by in Sub Queries? **
35. What is the Limit of small date time function? **
36. What is the @@error? **
37. What is the @@raise error? **
38. What is the @@row count? **
39. What is Date Diff function? **
40. What is Date Add Function? **
41. What is date part function? ***
42. What is coalesce function in SQL Server? ***
43. What is stuff function? ***
44. What is replacing function in SQL Server? ***
45. What are the sparse column and when we use it? ****

SQL Server Interview Questions: Views

1. What is the view in SQL Server? **
2. What are the updated views? ***
3. What are the materialized views or Indexed Views in SQL Server? ****
4. What is view with check option? ****
5. Write the Create syntax for Views. **
6. What is common table expression (CTE)? ***
7. What is difference between CTE and View? ****

 

SQL Server Interview Questions: Stored procedure

1. What is stored procedure in SQL Server? **
2. How to pass record set in stored procedure? ***
3. Is nesting possible in stored procedure? If yes How many number of times? ***
4. Write the create syntax for the procedure. **
5. How to return output parameter from stored procedure? ***
6. How to perform error handling in Stored procedure? ****

SQL Server Interview Questions: Function

1. What is the User defined functions? **
2. What are the difference types of UDF? **
3. What are difference between UDF and stored procedure? ***
4. Can we create a table in function? ****

SQL Server Interview Questions: Triggers

1. What is a trigger in SQL Server? **
2. What is the nesting level of triggers? **
3. What are the different types of triggers in SQL Server? ***

SQL Server Interview Questions: Cursors

1. What is the cursor in SQL server? **
2. What are the different types of cursor in SQL Server? ***
3. When to use Cursor in SQL Server? ***

SQL Server Interview Questions: Index

1. What is Index in SQL Server? ***
2. Explain different types of index in SQL Server? ***
3. What is filter index in SQL Server? ****
4. What is Covering Index? ****
5. What is index scan and index seek? ****
6. What is B+ tree index? ****
7. Explain the architecture of the index? ****
8. Explain the performance impact of index? ****
9. Can we create clustered index on null value column? ****
10. What are indexes in SQL Server? ****
11. How many clustered index can be created on the table? ****
12. How to enforce index on a query?  ****

SQL Server Interview Questions: Performance tuning

1. What is SQL Profiler?
2. Explain the use of SQL Profiler.
3. What is Database Tuning Advisor?
4. What is Execution Plan?
5. How to Read Execution Plan?
6. What are the statistics and the impact on SQL Server?
7. What are the table hint and how we can provide it on table?
8. How to read execution plan?
9. What are the algorithms does SQL Server used to fetch data?
10. What is bookmark lookup?

SQL Server Interview Questions: Transaction

1. What are the different types of transaction errors?
2. What is No lock?   
3. What happens if a transaction is failed in nested transaction, then other outer transactions will execute or not?
4. What is isolation level in SQL Server?
5. What are different types of isolation level in SQL Server?
6. What is default isolation Level for SQL Server?

SQL Server Interview Questions: Other Questions

1. Write a query to find the nth minimum and maximum.
2. Write a query to get the last record of the table.
3. Write a query to get the no rows of a table without using count or any other clause.
4. How many columns can be used with roll up or with cube command?
5. How many columns can be selected in a select statement?
6. How many columns can be selected in an insert statement?
7. What level of nesting is possible for sub Queries?
8. What level of nesting is possible for Triggers?
9. How many non-clustered indexes can be created on a table?
10. How many parameters can be provided to a stored procedure?
11. How many parameters can be provided to a UDF?
12. How many columns can be taken in update statement?
13. What is NO COUNT used for?
14. What is SET ANSI NULL ON used for?
15. What is arithmetic abort used for?
16. What is SET ROW COUNT used for?
17. What is SET ANSI padding?
18. What is SET ANSI WARNING on?
19. What is SET NO EXEC?
20. Which command using Query Analyzer will give you the version of SQL server and operating system?
21. How to delete duplicate records from table using query?