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

How can I enforce to use particular index?

Symphony,

1 6173

What is sorting and what is the difference between sorting and clustered indexes?

1 7992

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6333

What is the use of SCOPE_IDENTITY() function?

2 6371

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 8891

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12473

How many types of TRIGGERS are there in MS SQL Server?

CarrizalSoft Technologies, TCS, United Healthcare,

8 31330

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

United Healthcare,

1 5974

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

United Healthcare,

1 5774

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 25002

What is the query optimization statistics?

1 2853

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 6597

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

Cognizant, TCS,

12 15755

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 7758

explain the type of contraints

3 5421

Un-Answered Questions { SQL Server }

How to execute a sql statement using mssql_query()?

1051

How to reaname table name without using sp_Rename in sql server..?

996

What is clustered primary key?

1026

Is the order of columns in the set clause important in ms sql server?

969

What is the web service used for reporting services?

123

User wants only to display only pdf as export option in report manager. How to achieve this?

262

What are transactions in sql?

1060

What is lock escalation? : sql server database administration

1159

How to create median function?

164

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

980

How connect excel to sql server?

995

What samples and sample databases are provided by microsoft?

1037

How sql server enhances scalability of the database system?

1219

What is code near application topology?

279

What are locks in sql?

980

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