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 11079

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

1 5130

Advantages and disadvantages of stored procedures.

HCL,

2 8065

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,

2413

What is the difference between online clustering and Offline clustering?

IBM,

2474

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

IBM,

3 8991

What is the diffrence between update_one and auto_fix?

IBM,

3 11302

what are the advanced features in sql 2008?

Wipro,

2 6522

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 8065

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 13742

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

1 4078

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 6831

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 9013

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 9286

What is @@Identity in sql?

Cap Gemini,

1 6354

Un-Answered Questions { SQL Server }

Explain can SSRS reports Cache results?

161

Tell me what is a linked server?

1086

How to defragment table indexes?

1038

What are cursors stored procedures and triggers?

1082

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

939

How to get @@error and @@rowcount at the same time?

1083

What are “lock” hints?

1104

How to make remote connection in database?

1049

What is the default server name for sql server?

1231

How to create indexed view?

1104

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1120

What is SQL Server?

1271

What is the difference between indexing and hashing?

1221

Which trace flags are enabled in sql server?

1074

What is difference between equi join and inner join?

1038

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