SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Can sql servers link to other servers?

1034

Describe how to use the linked server?

1079

What are transactions in sql?

999

Explain the third normal form(3nf)?

903

What are the different types of collation sensitivity?

1068

List out the differences between global and local temp tables in sql server?

1013

Explain “@@rowcount” and “@@error” in sql server?

1018

What are the different types of join?

1115

Why are sql functions used?

1064

Explain mixed authentication mode of sql server?

1000

How can you insert null values in a column while inserting the data?

1230

Is it possible to update the views? If yes, how, if not, why?

983

What are the difference between “where” and “having” clause in sql server?

1025

What the different components in replication and what is their use?

925

What are subquery and its properties?

988

Un-Answered Questions { SQL Server }

What do you mean by an execution plan? How would you view it?

876

what do you understand by change data capture?

951

What is the parse query button used for?

991

What do you understand by a stored procedure?

1053

How much space does sql server 2016 take?

916

What are sql azure firewall rules?

106

What are different types of collation sensitivity?

954

Is natural join and equi join same?

922

How to override dml statements with triggers?

1100

What is a functions and types in sql server?

1027

Do comments need to go in a special place in sql server 2005?

824

Define outer join in sql server joins?

901

Explain steps of normalization?

948

What is the sql case statement used for? Explain with an example?

952

What is a group function explain with an example?

951

For More Un-Answered { SQL Server } Questions Click Here