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

Give an example of SQL injection attack ?

HAL,

1003

What is lookup override?

Informatica,

1022

Explain what you mean by 3 tier architecture.

TCS,

1071

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

Genpact,

1 2341

What is an active database?

HCL,

1006

What is used to replicate sessions between instances in coldfusion clusters?

HCL,

1067

How to transfer a table from one schema to another?

MCN Solutions,

994

Write the queries for commands like Create Table, Delete table, Drop Table etc.

HPCL, Hughes Systique Corporation,

1092

What is the difference RDBMS and Graph Database?

EXL,

1044

do views contain data ?

MCN Solutions,

957

What is difference between global temporary tables and local temporary tables?

Tech Mahindra,

1229

What is trigger and different types of Triggers?

QuestPond,

1138

What are difference between Cluster index and Non-Cluster index?

QuestPond,

1073

How to delete duplicate records based on single column from a table?

Petranics Solutions,

1047

Which Model uses the SET concept

Infosys,

982

Un-Answered Questions { SQL Server }

What is table level trigger?

1016

what is a deadlock? : Sql server database administration

1056

What is sql server management studio? : sql server management studio

1069

Is INSTEAD OF trigger directly applicable to Table ?

1010

What is multi-statement table-value user-defined function?

987

What is used to replicate sessions between instances in coldfusion clusters?

1067

Ms sql server index?

1060

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1923

Do you know what are the properties of the relational tables?

1028

What is the optimization being performed in oracle and SQL Server?

1047

What is difference between temp table and cte?

1012

What are the types of sql server?

1045

How do you trace the traffic hitting a sql server?

1136

What are the different Topologies in which Replication can be configured?

1182

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

184

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