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 9381

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 9084

HOW TO RENAME A COLUMN NAME

3 7311

what is cluster and nin-cluster index?

4 6929

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23279

What is difference beteen Migration and Upgrdation?

Satyam,

7 25079

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

4 27396

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31673

What is row by row processing ?

2 8552

can primery key be a non clustered index?

10 13299

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

1 5527

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9787

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

Wipro,

4 10206

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

8 10536

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

1 3759

Un-Answered Questions { SQL Server }

What is a mutating table error and how can you get around it?

1049

Can you name some of the dml commands in sql?

1031

What purpose does the model database server?

1098

What are the different types of sub-queries?

1043

What is the log shipping?

1001

Does an index slow down updates on indexed columns?

972

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

What is SQL Azure Data sync?

121

Why union all is faster than union?

913

What should be the fill factor for indexes created on tables? : sql server database administration

1138

What command is used to delete a table from the database in the sql server and how?

1113

What extended events?

1005

How to use transact-sql statements to access the database engine?

1067

What languages bi uses to achieve the goal?

1002

In which files does sql server actually store data?

904

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