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

How many nested transaction can possible in sql server?

Bank Of America,

3 10946

hi,i want t0 knom d syntax for a super key with an example

1 5066

Advantages and disadvantages of stored procedures.

HCL,

2 7960

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

HCL, Wipro,

2344

What is the difference between online clustering and Offline clustering?

IBM,

2416

When do u use clustered index and non-clustered index?

IBM,

3 8867

What is the diffrence between update_one and auto_fix?

IBM,

3 11190

what are the advanced features in sql 2008?

Wipro,

2 6418

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 7949

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 13627

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 4021

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 6643

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 8755

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

IBM, TCS,

7 9057

What is @@Identity in sql?

Cap Gemini,

1 6267

Un-Answered Questions { SQL Server }

What are the differences between union, intersect, and minus operators?

1086

How can you insert values in multiple rows using one Insert statement?

1096

How to manipulate data from one table to another table ?

969

What are different types of raid levels?

1168

What is the difference between truncate and delete commands?

1067

Explain external key management in sql server 2008

888

How to list all objects in a given schema?

1058

Explain what is lock escalation?

1064

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1393

Can you index views?

894

What is index, cluster index and nonclustered index?

995

How many types of database relationship in sql server?

1054

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2069

Explain can SSRS reports Cache results?

158

How sql server executes a statement with nested subqueries?

1026

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