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 23813

Can we create clustered index on non primary key column

ABC, CTS,

20 55562

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

1 10182

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

Microsoft,

2 12829

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

Eforce, Systematix,

26 33595

how to implement locking in sql server

Satyam,

3 9036

What is the difference between a Application Server and a Database

Oracle,

3 13394

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

CTS, MCN Solutions, Oracle,

15 69048

what is differece between union and union all

6 10431

Is trigger fired implicitely?

2 5809

how do we find every fifth record in a table

Aspire, HCL,

14 19306

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

Microsoft,

2 7163

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 7358

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

8 22115

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17548

Un-Answered Questions { SQL Server }

What are transactions in sql?

1144

List few advantages of stored procedure.

1038

What is thr feature of change data capture?

1039

What does nvl stand for?

1005

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1280

How to get the definition of a stored procedure back?

1028

What is 'Join' and explain its various types.

1221

After removing a table from database, what other related objects have to be dropped explicitly?

1108

How can I know what locks are running on which resource?

1006

What is the difference between mysql and mysqli?

1306

What are different types of raid levels?

1251

How to assign new column names in a view?

973

Which are the important points to note when multilanguage data is stored in a table?

1082

Can you move the resources after pausing the node? : sql server database administration

1179

Explain what are the authentication modes in sql server?

1087

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