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

what is difference between primary key and Unique

8 9355

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

SAP Labs,

3 9070

HOW TO RENAME A COLUMN NAME

3 7304

what is cluster and nin-cluster index?

4 6920

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23227

What is difference beteen Migration and Upgrdation?

Satyam,

7 25047

What are different types of Keys? Please explain all the keys with a suitable example.

4 27389

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31657

What is row by row processing ?

2 8544

can primery key be a non clustered index?

10 13271

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 5523

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9769

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

Wipro,

4 10196

How to find out name of all employees who has salary less than 200 Rs.?

8 10518

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 3754

Un-Answered Questions { SQL Server }

What is normalization 1nf 2nf 3nf?

1058

What stored by the msdb?

995

Can we do dml on views?

950

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1382

How to write a query with a full outer join in ms sql server?

1070

What are the reporting services components?

142

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

897

Explain about link server in sql server?

1051

What is snapshot parameter in ssrs?

150

How do I determine how many instances of sql server are installed on a computer?

1004

What is etl - extraction, transformation, and loading?

916

What is the difference between delete and truncate statements?

1071

What is the difference between locking and multi-versioning?

985

What do mean by xml datatype?

1089

What is user-defined functions? What are the types of user-defined functions that can be created?

1031

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