SQL Server Interview Questions and Answers - Part 1.

In this video we have covered some basic questions on SQL Server which are summarized below :-

Question 1 :- Explain normalization ?

Question 2 :- How to implement normalization ?

Question 3 :- What is denormalization ?

Question 4 :- Explain OLTP vs OLAP ?

Question 5 :- Explain 1st,2nd and 3rd Normal form ?

Question 6 :- Primary Key vs Unique key ?

Question 7 :- Differentiate between Char vs Varchar ?

Question 8 :- Differentiate between Char vs NChar ?

Question 9 :- Whats the size of Char vs NChar ?

Question 10 :- What is the use of Index ?

Question 11 :- How does it make search faster?

Question 12 :- What are the two types of Indexes ?

Question 13 :- Clustered vs Non-Clustered index

Question 14 :- Function vs Stored Procedures

Question 15 :- What are triggers and why do you need it ?

Question 16 :- What are types of triggers ?

Question 17 :- Differentiate between After trigger vs Instead Of ?

Question 18 :- What is need of Identity ?

Question 19 :- Explain transactions and how to implement it ?

Question 20 :- What are inner joins ?

Question 21 :- Explain Left join ?

Question 22 :- Explain Right join ?

Question 23 :- Explain Full outer joins ?

Question 24 :- Explain Cross joins ?