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,

1006

What is lookup override?

Informatica,

1040

Explain what you mean by 3 tier architecture.

TCS,

1077

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

Genpact,

1 2349

What is an active database?

HCL,

1013

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

HCL,

1072

How to transfer a table from one schema to another?

MCN Solutions,

1002

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

HPCL, Hughes Systique Corporation,

1108

What is the difference RDBMS and Graph Database?

EXL,

1047

do views contain data ?

MCN Solutions,

969

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

Tech Mahindra,

1238

What is trigger and different types of Triggers?

QuestPond,

1146

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

QuestPond,

1079

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

Petranics Solutions,

1050

Which Model uses the SET concept

Infosys,

984

Un-Answered Questions { SQL Server }

What is a document index?

1028

What is the command to change the recovery model?

1047

What is the current pricing model of SQL Azure?

104

What is sql server english query?

1128

What is the use of builtinadministrators group in sql server? : sql server security

1048

What is the difference between writing data to mirrored drives versus raid5 drives

932

How do I find query history in sql server?

942

Can we do dml on views?

956

How to create an multi-statement table-valued function?

996

How do I partition a table in sql server?

1041

Does full backup break log chain?

962

How to change the data type of an existing column with "alter table" statements in ms sql server?

982

What is the command used to recompile the stored procedure at run time?

1081

How you can change a cross join into an inner join?

973

What is sql collation?

1209

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