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 74132

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

Cognizant, CTS,

15 26649

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 12011

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

2 6720

Alternative way to DetDate() function?

5 9825

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 60201

How to delete an attribute from the emp table

4 9543

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,

1992

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

Infosys, TCS,

18 68312

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,

5924

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

iGate, Logica CMG,

1 9373

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 36834

Un-Answered Questions { SQL Server }

What is the user of Primary key?

985

What is the purpose of object explorer and its features? : sql server management studio

1212

How to convert a table data in XML format in sql server?

2541

What is inline table-value user-defined function?

1112

Explain the properties of a relational table?

1024

Explain how to use linked server?

991

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

How to create a Master database in SQL server ?

1088

How will you optimize a stored procedure optimization?

1040

What are the requirements to use odbc connections in php scripts?

1120

Explain mixed authentication mode of sql server?

1064

What is default port number for sql server 2000?

1046

What are the advantages of sql azure?

140

Explain in brief how sql server enhances scalability of the database system?

981

What is 4nf in normalization form?

1025

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