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 9619

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 9224

HOW TO RENAME A COLUMN NAME

3 7438

what is cluster and nin-cluster index?

4 7098

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23666

What is difference beteen Migration and Upgrdation?

Satyam,

7 25342

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

4 27589

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31851

What is row by row processing ?

2 8643

can primery key be a non clustered index?

10 13593

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

1 5597

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9999

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

Wipro,

4 10420

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

8 10776

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

1 3856

Un-Answered Questions { SQL Server }

What is the data type of time?

1019

What is difference between cte and view?

979

What are the requirements for sql server 2016?

936

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1089

How to search for a string in all stored procedure in sql server?

1061

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1694

Explain what is lock escalation and what is its purpose?

987

What is nolock?

1041

What is spatial and temporal data?

1050

Where can you find the error log information? : sql server database administration

1075

Explain about thread and memory management process of SQL?

1024

What is sql server agent and what are the two modes of authentication in sql server?

1113

List the data types available in mssql?

1108

List all the types of user-defined functions?

1192

What is meant by dirty read?

1047

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