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 74121

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

Cognizant, CTS,

15 26647

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 12007

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

2 6718

Alternative way to DetDate() function?

5 9823

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 60187

How to delete an attribute from the emp table

4 9541

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 4540

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

HCL,

1991

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

Infosys, TCS,

18 68299

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 8852

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

4 7316

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

ABC, TCS,

5923

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

iGate, Logica CMG,

1 9371

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 36825

Un-Answered Questions { SQL Server }

What are various ways to enhance the ssrs report?

981

How to deploy the Report?

138

What is the purpose of the model database?

1015

Mention the differences between substr and charindex in sql server.

1050

What is the difference between row_number and dense_rank?

881

How to truncate the log in sql server 2012? : sql server database administration

1284

Do you have any idea about the tcl commands?

962

How you trouble shoot when any job fails

1937

Explain what is the use of custom fields in report?

926

How can we solve concurrency problems?

1054

What are the tools available in market as an alternative to sql server reporting services?

131

Where is localdb stored?

942

Can we update data in a view?

1029

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1064

what are the disadvantages of cursors? : Sql server database administration

1029

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