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 6247

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

1 8067

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6479

What is the use of SCOPE_IDENTITY() function?

2 6509

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 9003

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12722

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

CarrizalSoft Technologies, TCS, United Healthcare,

8 31642

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

United Healthcare,

1 6072

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

United Healthcare,

1 5843

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 25259

What is the query optimization statistics?

1 2931

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 6721

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 16168

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

TCS,

2 7901

explain the type of contraints

3 5525

Un-Answered Questions { SQL Server }

How to view existing indexes on an given table using sys.indexes?

1152

What is the function of inner join?

1126

How to add a new dsn with the odbc driver for sql server?

1112

What are rest-style architecture's?

172

What programming language would you use to create embedded functions in ssrs?

191

What are the types of subscriptions in SQL Server replication?

1104

Â Explain what is sql override for a source taLle in a mapping?

1057

How you trouble shoot when any job fails

1984

what are different types of raid configurations? : Sql server database administration

1102

What is SQL Azure Firewall?

136

Explain about the command-line tool SQLCMD?

1144

What is difference between stored procedure and user defined function?

1170

How to remove duplicate rows from table except one?

1064

what is a check constraint?

1171

What do we have to check in database testing?

1056

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