- What is SQL
- Types of SQL Commands
- SQL statement processing order
- First, Second & Third Normal forms in database
- Denormalization, OLTP and OLAP
- Star Schema & Snow Flake Design
- State 4 different types of SQL join
- wild card operators
- Union & Union All
- Aggregate functions, group by clause, having keyword?
- subqueries & co-related queries?
- What are Indexes and how does it increase performance?
- How indexes Affect insert, update and delete performance (page split)?
- Difference between Clustered and Non-Clustered Indexes?
- What are triggers, inserted tables and deleted tables?
- Can you explain instead of and after triggers with a example
- What are stored procedures and why do we need them?
- What is use of ISNULL and Coalesce functions?
- What is Row_Number, Partition, Rank and DenseRank?
- What is CDC (Change data capture)?
- What is the difference between unique key and primary key?
- How can we implement Pivot & Unpivot in SQL Server?
- How does SQL Server store data in 8 KB page?
- Explain the need of SQL Server Agent.
- Comparing trigger functions and procedure
- Interview questions
- Can sql views be updated
- Find second highest
SQL Server
Subscribe to:
Posts (Atom)
No comments:
Post a Comment