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

What objects does the fn_my_permissions function reports on? : sql server security

1080

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1132

Differentiate between a having clause and a where clause.

1007

Explain the stored procedure?

1094

What functions can a view be used to performed?

1115

Describe the functionalities that views support.

1145

Explain primary key?

1005

What are partitioned views and distributed partitioned views?

1061

What are the basic functions for master, msdb, model, tempdb databases?

1095

Explain the concept of recursive stored procedure.

1021

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

981

What is dbcc? Give few examples.

1083

What is row_number function?

1058

What do you mean by an execution plan?

1186

What is a trace frag? Where do we use it?

1150

Un-Answered Questions { SQL Server }

What are extended events in sql server?

1005

What are different types of join?

1372

Explain difference between control flow and data flow?

1013

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1179

What is mapping schema?

1068

What are 3 ways to get a count of the number of records in a table?

1122

What is 'write-ahead log' in sql server 2000 ?

1106

what method you can use to reduce the overhead of Reporting Services data sources?

268

Why truncate is ddl command?

1111

How to create new tables with "create table" statements in ms sql server?

1106

What is truncate table?

999

How to create a user to access a database in ms sql server using "create user" statements?

995

What is optimistic concurrency?

1091

How many replicas are maintained for each sql azure db?

124

In which sql server version report builder introduced?

150

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