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 23583

Can we create clustered index on non primary key column

ABC, CTS,

20 54883

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

1 10050

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

Microsoft,

2 12711

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

Eforce, Systematix,

26 32634

how to implement locking in sql server

Satyam,

3 8864

What is the difference between a Application Server and a Database

Oracle,

3 13204

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

CTS, MCN Solutions, Oracle,

15 68399

what is differece between union and union all

6 10206

Is trigger fired implicitely?

2 5694

how do we find every fifth record in a table

Aspire, HCL,

14 18741

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

Microsoft,

2 7048

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 7206

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

8 21832

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17410

Un-Answered Questions { SQL Server }

What are the different types of indexes?

1118

What is use of except clause? How does it differ from not in clause?

1020

What are the steps to process a single select statement?

942

Do you know what is lock escalation?

1011

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1965

Write a sql query to display the current date?

1093

last function used in MS Access to convert sql what function will use in sql

2070

what is the difference between openrowset and openquery?

1087

What is a DBMS, query, SQL?

1046

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1946

What is log shipping?

960

Tell me what are the essential components of sql server service broker?

941

What is a transact-sql statement?

1059

What are advantages of ssrs or why we should use ssrs?

139

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1606

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