SQL-Server Interview Question.

 

1. What is Database Management System.
2. What is Relational Database Management  System.
3. What is Data Integrity.
4. What is Data Consistency.
5. What is Referential Integrity.
6. What is Cascade Delete.
7. What is Data Anomalies. Types of Data Anomalies.
8. What is Relationship in RDMBS and Different types of Relationship.
9. What is Normalization. Different kind of Normalization.
10. What is Denormalization.
11. Difference .MDF file and .LDF file in SQL-Server.
12. Difference between Attach and Restore in SQL-Server.
13. Difference between DML,DDL,DCL statement in SQL-Server.
14. Difference between Where and Having Clause.
15. Difference between Truncate and Delete command.
16. Difference between Identity and Sequence in SQL-Server.
17. Difference between @@identity, @scopeidentity, and @ident_current.
18. What is Constraints. Different types of Constraints In SQL-Server.
19. What is Primary Key and Foreign Key ad difference between Primary Key and Unique Key.
20. What is Composite Key, Alternate Key, Candidate Key and Super Key in RDBMS.
21. What is Indexes. Different types of Indexes in Sql-Server.
22. Use of Filtered Index, Spatial Index, Fulltext Index, Xml Index, ColumnStore Index in SQL-Server.
23. Difference between Cluster Index and Non Cluster Index.
24. What is Function. Difference types of Function.
25. Difference between Scaler Function and Table Valued Function in SQL-Server.
26. Difference between IsNull() and Coalesec() function.
27. Difference between Cast() and Convert() function in Sql-Server.
28. Difference between Row_Number(), Dense_Rank(),Rank() function .
29. Difference between Floor(),Rand(),Ceiling() function in SQL-Server.
30. Difference between DateDiff(), DatePart() Function in SQL-Server.     
31. What is Procedure .Different types of Procedure in SQL-Server.
32. Difference between Procedure with Output Value and Procedure with Return keyword.
33. Difference between Function and Procedure.
34. What is Trigger in SQL-Server. Difference types of Trigger in SQL-Server.
35. What is Magic Tables in SQL-Server.
36. What is Inserted and Deleted table in SQL-Server.
37. What is Join in SQL-Server. Difference types of SQL-Server.
38. Explain Inner Join, Left Join, Right join, Full-Join, Cross Join .
39. What is Apply operator in SQL-Server. Types of Apply Operator.
40. Difference Between Join and Apply in SQL-Server.
41. What is Union and Union All Operator in SQL-Server.
42. Difference between Union and Union All .
43. Difference between Join and  Apply operator in SQL-Server.
44. What Is Temp table. Difference between local and global temp table.
45. What is View. Types of view in SQL-Server. Benefit of using view in SQL-Server database.
46. What is CTE.
47. What is Cursor in SQL-Server.
48. What is Transaction. Explain ACID properties of Transaction.