SQL Server

  • 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


No comments:

Post a Comment