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 are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1020

What is rolap and its advantage? : sql server analysis services, ssas

1277

What is left outer join in sql server joins?

1034

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

1100

What is 3nf normalization form?

1104

Explain index in sql server?

1012

What is right outer join in sql server joins?

1178

What is outer join in sql server joins?

1112

What is 4nf in normalization form?

1015

What is onf in normalization form?

1051

Explain stored procedure?

1047

Explain linked server in sql?

1210

What is a self join in sql server?

1122

What is self join in sql server joins?

1052

We need to perform what steps in the following order to work with a cursor?

1214

Un-Answered Questions { SQL Server }

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1039

Can you always create a cache of a report?

172

How to list all tables in the database using odbc_tables()?

1042

What is a data collection table?

1004

What is the function of inner join?

1064

List out what other servers you can use with ssrs?

137

Explain rdbms?

1024

How to get a list of columns in a view using the "sp_help" stored procedure?

1030

Define Wed Edition in SQL Azure?

100

How are the unique and primary key constraints different?

1069

How many replicas are maintained for each sql azure db?

124

What is sql service broker?

972

How do I find the sql server database version?

1001

How to send a ssrs report from ssis?

176

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1669

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