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?

1085

Describe how to use the linked server?

1143

What are transactions in sql?

1060

Explain the third normal form(3nf)?

943

What are the different types of collation sensitivity?

1123

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

1061

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

1089

What are the different types of join?

1173

Why are sql functions used?

1119

Explain mixed authentication mode of sql server?

1064

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

1280

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

1029

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

1072

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

952

What are subquery and its properties?

1049

Un-Answered Questions { SQL Server }

What is report subscription?

125

What are group functions in query statements in ms sql server?

1010

What is catalog views?

1068

Can you please explain the difference between primary keys and foreign keys?

1110

Can we write a distributed query and get some data which is located on other server and oracle database?

1231

What is the difference between truncate and delete commands?

1068

Define views.

1012

Which rendering formats are affected by the pagesize properties?

144

How data can be copied from one table to another table?

950

What is ms sql server service broker?

992

What do you understand by triggers?

922

What are the indexes in sql server?

1115

How to use go command in "sqlcmd"?

1204

How do we synchronize On-Premise SQL server with SQL Azure?

122

What is a database in ms sql server?

1057

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