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

Why we need a group by clause?

4 10347

What is a join and their types?

Challenger Financial,

2 7545

What is the difference between referencing and joining?

1 4128

What is the difference between constraints and triggers?

Wipro,

9 36593

What is ACID Property of Transaction?

10 37920

What is an index?

Yardi Software,

8 15397

What is normalization and its forms?

Challenger Financial,

4 14312

What is a cursor in SQL Server 2000 and their types?

8 19243

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 54289

How do we return a record set from a Stored Procedure in SQl server 2000?

3 6712

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 25475

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 52847

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 112942

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 6665

Which is best Subquery (or) joins in sql server? explain why

2 11356

Un-Answered Questions { SQL Server }

What the different types of Replication and why are they used?

1071

What is query and its types?

915

Explain about unique identifier data type in sql server?

914

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1049

What is correlated subquery in sql server?

1072

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1169

Do you know what is xpath?

1087

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

945

You want to implement the many-to-many relationship while designing tables. How would you do it?

997

what is database replicaion? : Sql server database administration

1193

Does view occupy space?

942

What are different types of schemas?

947

Explain what is the difference between a local and a global temporary table?

1000

Does a server store data?

923

What is local temp table?

960

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