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

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

Infosys,

5 23785

Can we create clustered index on non primary key column

ABC, CTS,

20 55493

What are Sql Reporting Services and analysis services? Can u Explain

1 10168

What r sql reporting services and analysis services? how can we use it.

Microsoft,

2 12816

is there more the two primary key in a single table?

Eforce, Systematix,

26 33488

how to implement locking in sql server

Satyam,

3 9023

What is the difference between a Application Server and a Database

Oracle,

3 13365

What is the difference between 2-Tier architecture and 3-Tier architecture

CTS, MCN Solutions, Oracle,

15 68973

what is differece between union and union all

6 10394

Is trigger fired implicitely?

2 5798

how do we find every fifth record in a table

Aspire, HCL,

14 19236

What is the appropriate number of test cases that you can write on a database?

Microsoft,

2 7157

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

Microsoft,

2 7348

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 22088

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17536

Un-Answered Questions { SQL Server }

Explain trigger and trigger types?

1041

Tell me what is use of except clause? How it differs from not in clause?

1003

What should be the fill factor for indexes created on tables? : sql server database administration

1186

Determine how to use the inserted and deleted pseudo tables?

1047

How can you stop stored procedures from recompiling?

954

What do you mean by authentication modes in sql server?

1141

What is faster join or union?

1325

What is db stored procedure?

948

What is the sql case statement used for? Explain with an example?

1045

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2279

What does this statement do @@rowcount?

1016

What are the parts of a function?

994

What are the components of sql server service broker?

1074

What are the differences between DDL, DML and DCL in SQL?

1283

How does recursive cte works in sql server?

1061

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