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 to check if a User database is locked?

TCS,

1112

Explain what is meant by replication of database?

Cap Gemini,

1103

How to add additional conditions in SQL?

Amdocs,

1061

What is the optimization being performed in oracle and SQL Server?

Cap Gemini,

1093

write an SQL query to list the employees who joined in the month of January?

Agilent, Amdocs,

1733

Is BCNF better than 2NF & 3NF? Why?

Akamai Technologies,

1102

Write an SQL query to obtain the 2nd highest salary.

Akamai Technologies,

1122

Explain various On-Delete options in a DB table. Which is the default option?

Akamai Technologies,

1528

Benefits of Stored Procedures?

Wipro,

1037

What are the advantages to use stored procedures?

Ernst Young,

1175

What is SQL Server?

Atos Origin,

1264

How can we improve performance by using SQL Server profiler?

QuestPond,

1100

How do you send email on SQL Server?

MindCracker,

1109

How to concatenate two strings in SQL Server.

HCL,

1201

In which format does an image save in SQL Server database ?

MCN Solutions,

1051

Un-Answered Questions { SQL Server }

What is federation member?

116

What new data source types were added in ssrs 2014?

169

List some case manipulation functions in sql?

1083

What is difference between delete & truncate commands?

1137

How to rebuild master databse?

1125

How sql server executes a statement with nested subqueries?

1086

how you can deploy an ssrs report?

185

What is the default server name for sql server?

1228

How can we use ConnectorJ JDBC Driver with MS SQL?

1050

can an automatic recovery be initiated by a user? : Sql server administration

991

Can we insert data if clustered index is disabled?

981

Who is the owner of a schema in ms sql server?

1114

What is replication with database mirroring? : sql server database administration

1143

Define indexes?

1092

What are the restrictions while creating batches in sql server?

1108

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