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 11087

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

1 5139

Advantages and disadvantages of stored procedures.

HCL,

2 8068

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,

2416

What is the difference between online clustering and Offline clustering?

IBM,

2479

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

IBM,

3 9000

What is the diffrence between update_one and auto_fix?

IBM,

3 11308

what are the advanced features in sql 2008?

Wipro,

2 6531

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 8073

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 13749

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

1 4082

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 6840

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 9022

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 9296

What is @@Identity in sql?

Cap Gemini,

1 6355

Un-Answered Questions { SQL Server }

List out some of the requirements to set up a sql server failover cluster?

1081

Can we return Data from 4(more than 1) tables in stored procedure?

1110

how to trace the traffic hitting a sql server? : Sql server database administration

1957

What is indexing in sql server with example?

1044

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

1455

Explain system functions or built-in functions? What are different types of system functions?

1043

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1301

What is change tracking in sql server?

1078

Why use triggers?

1069

What is the maximum size of sql server database?

1064

What is order of B+tree?

1155

Does full backup break log chain?

1016

Mention what are the core components of ssrs?

330

Which tcl commands are available on the sql server?

1143

what are the Prerequisites for Replication?

11445

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