Sql Server Interview questions Part 1

After having been rejected from almost a dozen companies , i thought of at least sharing some of the interview questions which i have faced till now.They make look repetitive but these are the questions which are still asked by companies looking for sql developer.

Q1.What is RDBMS.
Q2.What is third and fourth normal forms
Q3.What are views.
Q4.What is primary key in a datatable.
Q5What is unique key and what is difference between unique key and primary key.
Q6.What is identity column
Q7.What is difference between scope_identity(),identity_current() and identity()
Q8.What are joins ,when do we need them.
Q9.What is left outer join and right outer join.
Q10.What is self join.
Q11.What is cross join.
Q12.What are correlated queries.
Q13.What are cursors
Q14.What are table variables.
Q15.What are temporary tables.
Q16.What are stored procedures.
Q17.What are functions.
Q18.Can a unique key be primary key
Q19.Can we create non clustered index on primary key
Q20.What is difference between functions and stored procedures
Q21.What is Replace function in sql server.
Q22.What is STUFF function in sql server.
Q23.What is a Sparse column
Q24.How to get non common data from two tables.
Q25.Can stored procedures or functions can contain trigger
Q26.What is CTE
Q27.What is difference between temporary tables and table variables