Interview Questions

SQL Interview Questions

1. What is recursive stored procedure?
2.What is different between Unique and Primary Key?
3.Use of Trigger?
4.Cluster Index / Non Cluster Index?
5. How to join two tables?
6.What is Sub Queries?
7.How many join in SQL / do you know?
8.What is Local & Global tables?
9.Different between SP and a View?
10.What are the default  DBs are in SQL Server?
11.Different between Stored Procedure and Functions?
12.How many type of Views?
13.Exceptions?
14.Do we need to use RETURN for out parameters in Stored Procedures?
15.What is the size of you DB?
16.What is T-SQL?
17.How to increase query performance?
18.When you use Temp tables?
19.What is dirty read?
20.What does the Truncate?
21.What are the DDL Command?
22.ACID in SQL Server
23.Different between @IDENTITY,  @SCOPE_IDENTITY, @IDENT_CURRENT?
24.What is Index Seek and Index Scan?
25.Normal Forms
26.what are the DDL and DML operations
27.what is cursor?
28.what is procedure?
29.what is view?
30.what is different between SP and View?
31.what are the different between 2012/2016 and 2017
31.what is the different between ON clause and where clause?
32.Different between INNER and FULL JOIN?
33.How to delete duplicate records in table which doesn't have any         
       unique/primary columns?
34.What is CROSS APPLY?
35. Lookups in SQL Server execution plan
36. How to select a data from excel using SQL query.
37. How many ways we can Sort  a data in SSRS
38. What is the Interactive sorting in SSRS, what are the steps
39. What is Report Manager in SSRS.
40. What is constraint & what are those
41. What is the use CHECK Constraint
42. What is the use of DEFAULT Constraint
43. What is DrillDown in SSRS & Tell me the steps.
44. What is DrillThrough in SSRS & Tell me the steps.


Please give you comments :)