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 6252

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

1 8076

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6486

What is the use of SCOPE_IDENTITY() function?

2 6520

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 9010

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12735

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

CarrizalSoft Technologies, TCS, United Healthcare,

8 31645

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

United Healthcare,

1 6077

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

United Healthcare,

1 5848

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 25264

What is the query optimization statistics?

1 2936

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 6724

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 16190

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

TCS,

2 7903

explain the type of contraints

3 5528

Un-Answered Questions { SQL Server }

What is wide table?

1017

Why use view instead of a table?

1005

How to concatenate two binary strings together?

1175

Define primary key?

1202

What is parameterized reports in ssrs ?

163

What is the partitioning method?

1069

What are triggers? How do you invoke a trigger on demand?

1368

Is sql server implemented as a service or an application? : Sql server database administration

999

What is resource governor in sql server?

1052

Explain about remote stored procedure?

1062

What do you mean by stored techniques? How would we use it?

1086

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1943

What are the diifferences between the ms sql server vs mysql?

1240

What is difference between Datepart() and Datename() in SqlServer?

1265

Explain the purpose of indexes?

1026

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