Posts

Showing posts from February, 2024

Index

1. What is Index https://csharp-video-tutorials.blogspot.com/2013/08/part-35-indexes.html 2. Clustered and non-clustered Index   Sql server, .net and c# video tutorial: Part 36 - Clustered & NonClustered indexes (csharp-video-tutorials.blogspot.com)

Top SQL Interview Questions

 Q1: Define a Temp Table Q2: What is a VIEW? Q3: What is PRIMARY KEY? Q4: What is Normalization? Related To: Databases Q5: What is DEFAULT? Q6: What is FOREIGN KEY? Q7: What is the difference between TRUNCATE and DELETE? Related To: MySQL Q8: What is the difference between Data Definition Language (DDL) and Data Manipulation Language (DML)? Related To: MySQL, T-SQL, Databases Q9: Define ACID Properties Related To: Databases Q10: Discuss INNER JOIN ON VS WHERE clause (with multiple FROM tables) Q11: What is the difference between INNER JOIN and OUTER JOIN? Q12: What is the difference between JOIN and UNION? Q13: What is the difference between UNION and UNION ALL? Q14: What is the difference between WHERE clause and HAVING clause? Q15: What is the difference between INNER JOIN, OUTER JOIN, FULL OUTER JOIN? Q16: Describe the difference between truncate and delete? Q17: What is Denormalization? Related To: Databases Q18: What is the difference between Clustered and a Non-clustered inde...