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 the advantages of log shipping?

1043

Why are views required in the sql server or in any other database?

1004

List the different index configurations possible for a table?

985

Where sql server usernames and passwords are stored in a sql server?

1040

List the various tools available for performance tuning?

929

What is a heap?

1087

Can we take the full database backup in log shipping?

999

What are the 2 types of classifications of constraints in the sql server?

1184

What is an execution plan?

1244

What are the different types of columns types constraints in the sql server?

1137

What is the stored procedure?

1054

What are the advantages of the mirroring?

1150

What are the common performance issues in sql server?

976

What is update_statistics command?

1121

What is the command used to get the version of sql server?

1 1598

Un-Answered Questions { SQL Server }

What is sql server management studio? : sql server management studio

1128

In which sql server version report builder introduced?

152

What is it unwise to create wide clustered index keys?

1051

what's the difference between a primary key and a unique key? : Sql server database administration

991

Can sql servers linked to other servers like oracle?

1012

Can a table have 2 primary keys?

1034

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1257

What is sql server profiler trace data file?

1180

What is difference between oltp and olap?

1099

What are the rendering extensions of ssrs?

160

How will you know when statistics on a table are obsolete?

1132

how can you attach more than 20 ldf files in sql server

2053

Explain active/passive and active/active cluster configurations?

1111

How can we use ConnectorJ JDBC Driver with MS SQL?

1053

What are the different types of cursor?

1157

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