Posts

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 are the difference between Clustered and a Non-clustered index?...

C# Interview Questions

Q1: What is an object? Q2: What is the difference between continue and break statements in C#? Q3: What is C#? Q4: What are Property Accessors? Q5: What are Nullable types in C#? Q6: What are Reference Types in C#? Q7: What are generics in C#? Q8: What is an Abstract Class? Q9: What is namespace in C#? Q10: What is Serialization? Q11: What are dynamic type variables in C#? Q12: Can this be used within a static method? Q13: In how many ways you can pass parameters to a method? Q14: What is the difference between a struct and a class in C#? Q15: What are the different types of classes in C#? Q16: What is Boxing and Unboxing? Related To: .NET Core Q17: What is the difference between string and StringBuilder in C#? Q18: How is Exception Handling implemented in C#? Q19: What is LINQ in C#? Related To: LINQ Q20: Can multiple catch blocks be executed? Q21: What is Enum in C#? Q22: What are partial classes? Q23: Why to use finally block in C#? Q24: What you understand by Value types and Refere...