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 6159

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

1 7982

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6321

What is the use of SCOPE_IDENTITY() function?

2 6354

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 8873

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12445

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

CarrizalSoft Technologies, TCS, United Healthcare,

8 31301

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

United Healthcare,

1 5965

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

United Healthcare,

1 5765

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 24977

What is the query optimization statistics?

1 2844

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 6587

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 15725

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

TCS,

2 7748

explain the type of contraints

3 5415

Un-Answered Questions { SQL Server }

How to configure and test odbc dsn settings?

1155

What are the different methods available under sqlcommand class to access the data?

1118

What is transact-sql ddl trigger?

1104

Do comments need to go in a special place in sql server 2005?

853

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

976

How to manipulate data from one table to another table ?

965

Explain what are various ways to enhance the ssrs report?

1042

What is a result set object returned by odbc_exec()?

1022

in the physical file layout, where should the transaction log be stored in relation to the data file?

990

What are the grouping functions?

927

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

960

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1043

Explain having clause and where clause?

1049

What are drillthrough reports?

155

Explain the properties of subqueries in sql server?

1078

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