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?

1136

Describe how to use the linked server?

1201

What are transactions in sql?

1136

Explain the third normal form(3nf)?

982

What are the different types of collation sensitivity?

1176

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

1108

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

1132

What are the different types of join?

1239

Why are sql functions used?

1182

Explain mixed authentication mode of sql server?

1116

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

1343

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

1082

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

1131

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

997

What are subquery and its properties?

1099

Un-Answered Questions { SQL Server }

What is the main difference between ‘between’ and ‘in’ condition operators?

1276

When would you use it?

1041

How do I setup a local sql server database?

1070

Do you know what is sql injection?

1041

How do I shrink an ldf file?

1038

How to create new tables with "select ... Into" statements in ms sql server?

1047

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

Explain linked server in sql?

1292

How will you find out if there are expensive SQL statements running or not?

1069

What are the advantages of stored procedure in sql server?

930

What are the advantages of log shipping?

1039

How do I view a trc file?

978

Sql server reporting services vs. Crystal reports.

140

Can we update data in a view?

1079

How to write a query with a right outer join in ms sql server?

960

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