SQL SERVER INTERVIEW QUESTIONS

Q 1.How do INNER JOIN and OUTER JOIN differ ?

Q 2.What is a subquery? Explain with an example ?

Q 3.What are the different types of constraints in SQL ?

Q 4.What is a stored procedure, and how does it differ from a function ?

Q 5.What are indexes in SQL, and why are they important ?

Q 6.What are aggregate functions in SQL? Provide some examples. ?

Q 7.How do VARCHAR and CHAR differ ?

Q 8.What is the purpose of the WHERE clause? ?

Q 9.Explain ACID properties in the context of SQL. ?

Q 10.What is SQL, and what are its different types? ?

Q 11.What is normalization, and how does it differ from denormalization ?

Q 12.What is a trigger in SQL? Provide an example ?

Q 13.Explain the difference between SQL and MYSQL ?

Q 14.What are the different types of joins in SQL? Provide examples ?

Q 15.Explain the different types of normal forms ?

Q 16.What are transactions in SQL, and how can you manage them ?

Q 17.What is the difference between DELETE,TRUNCATE, and DROP commands ?

Q 18.What is the difference between GROUP BY and HAVING clauses ?

Q 19.What are primary keys and foreign keys ?

Q 20.What is a Common Table Expression (CTE) ?

Q 21.What are the different types of SQL data types ?

Q 22.What is a self-join? Provide an example ?

Q 23.How does the EXISTS clause work ?

Q 24.Explain the RANK() and DENSE_RANK() functions in SQL ?

Q 25.What is the purpose of INDEX in SQL? ?