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,

1 1059

What is lookup override?

Informatica,

1 1088

Explain what you mean by 3 tier architecture.

TCS,

1 1136

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

Genpact,

1 2445

What is an active database?

HCL,

1 1078

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

HCL,

1 1116

How to transfer a table from one schema to another?

MCN Solutions,

1 1062

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

HPCL, Hughes Systique Corporation,

1 1186

What is the difference RDBMS and Graph Database?

EXL,

1 1095

do views contain data ?

MCN Solutions,

1 1030

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

Tech Mahindra,

1 1292

What is trigger and different types of Triggers?

QuestPond,

1 1208

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

QuestPond,

1 1143

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

Petranics Solutions,

1 1116

Which Model uses the SET concept

Infosys,

1 1049

Un-Answered Questions { SQL Server }

What are the different SQL Server Versions you have worked on?

1071

How raid can influence database performance?

1093

what is the difference between openrowset and openquery?

1174

What is a view in sql?

1033

What is normalization and what are the advantages of it?

1042

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1277

List out the different types of locks available in sql server?

1037

Explain “row_number()” in sql server with an example?

1061

How can I check that whether automatic statistic update is enabled or not?

1101

Can you index views?

946

What are the different types of subquery?

1222

Explain system functions or built-in functions? What are different types of system functions?

1052

Why should you use or avoid select * statements?

1094

What are the source of constraints?

994

How efficient you are in oracle and SQL server?

1234

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