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,

1037

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,

1012

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,

1001

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

HPCL, Hughes Systique Corporation,

1106

What is the difference RDBMS and Graph Database?

EXL,

1047

do views contain data ?

MCN Solutions,

968

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

Tech Mahindra,

1238

What is trigger and different types of Triggers?

QuestPond,

1143

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,

1049

Which Model uses the SET concept

Infosys,

984

Un-Answered Questions { SQL Server }

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

977

Why I am getting this error when dropping a database in ms sql server?

1072

What are the requirements on sql server network connections?

993

what is bit datatype? : Sql server database administration

916

What is the report builder?

139

what purpose does the model database serve? : Sql server database administration

977

What are system databases into sql server (2005/2008) : sql server database administration

1012

How to list all dsn entries on your local machine using odbc_data_source()?

1037

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1029

what is a transaction and what are acid properties? : Sql server database administration

1024

What is mssql?

985

What are the general features of sql server management studio? : sql server management studio

1076

Working with TLogs

1832

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1015

Explain linked server in sql?

1218

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