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 10934

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

1 5053

Advantages and disadvantages of stored procedures.

HCL,

2 7944

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,

2336

What is the difference between online clustering and Offline clustering?

IBM,

2413

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

IBM,

3 8855

What is the diffrence between update_one and auto_fix?

IBM,

3 11170

what are the advanced features in sql 2008?

Wipro,

2 6412

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 7942

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 13619

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

1 4016

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 6626

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 8744

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 9021

What is @@Identity in sql?

Cap Gemini,

1 6254

Un-Answered Questions { SQL Server }

What is extent? Types of extents?

1179

How column data types are determined in a view?

956

Explain the relational database management system (rdbms)?

1085

How can I create a new template for import ? : sql server management studio

1068

What is the purpose of a table?

958

Can we insert data into view sql server?

925

Explain about service Broker functions?

1028

what is checksum in sql server.........???

1682

What is difference between Datepart() and Datename() in SqlServer?

1203

How to round a numeric value to a specific precision?

1070

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1083

Explain the truncate command? : SQL Server Architecture

1166

How efficient you are in oracle and SQL server?

1147

What is data compression? : sql server database administration

965

Difference between uniqe index and uniqe constraint?

973

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