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,

1069

Explain what is meant by replication of database?

Cap Gemini,

1031

How to add additional conditions in SQL?

Amdocs,

1022

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

Cap Gemini,

1049

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

Agilent, Amdocs,

1677

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

Akamai Technologies,

1047

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

Akamai Technologies,

1078

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

Akamai Technologies,

1466

Benefits of Stored Procedures?

Wipro,

964

What are the advantages to use stored procedures?

Ernst Young,

1109

What is SQL Server?

Atos Origin,

1213

How can we improve performance by using SQL Server profiler?

QuestPond,

1053

How do you send email on SQL Server?

MindCracker,

1064

How to concatenate two strings in SQL Server.

HCL,

1149

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

MCN Solutions,

1001

Un-Answered Questions { SQL Server }

What is normalization? Explain its different types?

1088

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1163

How to attach adventureworkslt physical files to the server?

1106

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

Explain how you can configure a running aggregate in SSRS?

163

Can a unique index be created on a column, which contains null?

919

How to insert stored procedure result into temporary table?

1015

Write a SQL query to make a column as unique?

1038

What is transaction server auto commit?

1060

What is sql server transaction log file?

1054

How to create new table with "create table" statements?

1107

How many types of triggers in sql server?

1030

what are the different ways to return the rowcount of a table?

1000

How to list all stored procedures in the current database using ms sql server?

1132

Explain what are various ways to enhance the ssrs report?

1044

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