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

write the query for find the top 2 highest salary in sql server

Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

36 75424

how to retrive only second row from table in sql server 2000?

Cognizant, CTS,

15 27135

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

tdfc, vsworx,

9 12292

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 6830

Alternative way to DetDate() function?

5 10040

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

Oracle, Scend, TechInfini,

35 61547

How to delete an attribute from the emp table

4 9733

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 4652

How we create SQL Server 2005 Reporting Services ? Give me Sample

HCL,

2051

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

Infosys, TCS,

18 69129

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

Idea,

1 8949

how to find out the repeated value from table using groupby function?

4 7478

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

ABC, TCS,

5988

What is mean by "fill factor" ? and what is mean by "Index "in sql?

iGate, Logica CMG,

1 9458

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 37225

Un-Answered Questions { SQL Server }

What is role playing dimension with two examples? : sql server analysis services, ssas

1060

What is equi join with example?

1243

Explain forward - only cursors?

1133

Difference between DELETE and TRUNCATE?

1104

What do you know about normalization and de- normalization?

981

What are the 3 types of schema?

1191

What is dynamic cursor in SQL SERVER?

1150

What is bookmark link in ssrs?

251

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1021

How to execute stored procedure in select statement sql server?

1132

Why transaction is important?

1032

Why truncate is ddl?

1144

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1126

What is report snapshot in ssrs?

280

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1080

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