SQL Server Interview Questions and Answers

In this course you will find most frequently asked sql server interview questions

Below questions are included -

What is a DBMS?

What is RDBMS?

What are query types in a database?

What is candidate key

What is unique key

What is surrogate

What is Primary Key

What is default constraint

What is unique index

What is Distributed Tables

What is ACID properties?

What are the sql commands available?

What is temporary tables

What is local temporary tables

What is a table variable?

Which is faster a table variable or a temp table?

What is a stored procedure

What are the types of indexes available in SQL Server?

What is Clustered Index?

What is Nonclustered Index?

What is hash index?

What is memory-optimized Nonclustered?

What is unique index?

What is columnstore index?

What is Index with included columns?

What is index on computed columns

What is filtered index?

What is spatial index

What is xml index?

What is full text index?

What is recursive sp?

WHat is having clause

What is an er diagram

what is normalization

What is COALESCE in SQL Server?

What is CTE?

What is inner join?

what is outer join?

what is full join?

What is self join?

What is Cross Join?

What is merge join?

What is a function?

What is system function?

What is user defined function?

What is the difference between UNION and UNION ALL

What are the differences between delete and truncate?

What are the differences between Clustered Index and Non Clustered Index

What are the differences between functions and stored procedure?

What is the difference between SQL and PL/SQL?

What is the difference between in and exists

What is the difference between inner join and outer join

What is the difference between join and inner join

What is the difference between isnull and coalesce function

What is the difference between claustered index and non clustered index

What is difference between primary key and surrogate key

What is the difference between primary key and unique

What is the difference between Primary Key and Foreign Key?

How many columns can be taken in update statement?

How many types of relationships available in SQL Server

How many parameters can be provided to a UDF

How do you delete duplicate rows from a table without any keys

How do you improve stored procedure performance?

How do you improve a sql query performance?

When you should use clustered index?

When you should use non-clustered index?

what is ldf and mdf