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 10800

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

1 4989

Advantages and disadvantages of stored procedures.

HCL,

2 7837

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,

2283

What is the difference between online clustering and Offline clustering?

IBM,

2367

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

IBM,

3 8749

What is the diffrence between update_one and auto_fix?

IBM,

3 11030

what are the advanced features in sql 2008?

Wipro,

2 6302

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 7831

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 13510

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

1 3951

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 6479

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 8537

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 8832

What is @@Identity in sql?

Cap Gemini,

1 6176

Un-Answered Questions { SQL Server }

How many partitions a clustered index has by default in sql server 2012?

1055

What are subqueries in sql server? Explain its properties.

972

Explain sql server authentication modes?

1083

What is dbcc? Give few examples.

962

What is meant by datasource?

878

What is the difference between for xml raw and for xml auto?

985

What were the latest updates to SQL Azure service?

109

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

863

What is difference between join and natural join?

903

How to configure odbc dsn with different port numbers?

1032

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1331

What is the purpose of floor function?

983

What is the cartesian product of the table?

913

What is set nocount on and what is set nocount off?

893

What are the benefits of normalization?

1053

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