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 is encryption key?

139

What is cached report?

150

What are parameterized reports? What are cascading parameters in ssrs reports?

165

What is the name of reporting services config file and what’s it’s used for?

153

What is data set in report?

149

What programming language would you use to create embedded functions in ssrs?

191

What are data regions?

140

What are the new features of sql server 2008 r2 reporting service?

212

Mention what are the different types of ssrs reports?

158

In case you have filters in your report, when filters will be applied in cached report instance?

121

Which language rdl files made of?

141

What are the new features of sql server 2012 reporting service?

141

How to send a ssrs report from ssis?

185

What are the limitations in ssrs on sql server express edition?

195

What are the drawbacks of reporting in ssrs?

159

Un-Answered Questions { SQL Server }

How to modify an existing user defined function?

1178

Can another user execute your local temporary stored procedures?

1043

What is 2nf normalization?

1096

Define outer join?

1059

What is a trigger in sql server?

1245

Where actually sql azure database is hosted?

167

how can you check the level of fragmentation on a table? : Sql server administration

1045

What are “lock” hints?

1110

Explain what is the difference between union and union all?

1077

How except clause is differs from not in clause?

1015

What are the five major components of a dbms?

978

How column data types are determined in a view?

1019

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1118

What is spatial and temporal data?

1055

What structure can you implement for the database to speed up table reads?

1249

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