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,

1066

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

Cap Gemini,

1095

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

Agilent, Amdocs,

1737

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

Akamai Technologies,

1103

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

Akamai Technologies,

1123

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

Akamai Technologies,

1530

Benefits of Stored Procedures?

Wipro,

1037

What are the advantages to use stored procedures?

Ernst Young,

1177

What is SQL Server?

Atos Origin,

1269

How can we improve performance by using SQL Server profiler?

QuestPond,

1105

How do you send email on SQL Server?

MindCracker,

1114

How to concatenate two strings in SQL Server.

HCL,

1203

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

MCN Solutions,

1054

Un-Answered Questions { SQL Server }

What is mapping schema?

1068

What happens when converting big values to integers?

1057

What is importing utility?

1037

What happens if null values are involved in comparison operations?

1039

What do you understand by triggers and mention the different types of it?

996

How to deploy the Report?

140

How to select some specific rows from a table in ms sql server?

1054

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2821

Can group functions be used in the order by clause in ms sql server?

1065

What are the types of normalization?

1073

What does man by sql wildcard characters in sql server?

1103

Does index speed up select statements?

1072

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

1028

What are the advantages of policy management?

1042

What is sharding?

116

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