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

Are all views updatable ?

MCN Solutions,

1146

How each E-R model constructs can be mapped to the relational model?

HCL,

994

Tell me about normalization in DBMS.

Honeywell, Zomato,

993

what is the difference between count(*) and count(1) ?

MCN Solutions,

1079

Relational calculus is what type of language?

HCL,

1030

How can i Relate Tables in SSIS

HCL,

1076

What are audit control procedures?

Ernst Young, Thomson Reuters,

984

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

MCN Solutions,

976

What is the Disadvantage of indexed sequential file.

HCL,

1078

Explain Geography datatype in SQL Server

Infosys,

1122

What is the difference between implicit and explicit transaction?

1006

Tell me about joins in database system and explain each in detail.

Axtria, ITC Indian Tobacco Company,

1042

What is SubQuery in SQL Server 2008

HCL,

1017

How to find Duplicate Records In table?

HCL,

1013

What is the beast way to write CTE in SQL Server ?

HCL,

1039

Un-Answered Questions { SQL Server }

What is the cpu pressure?

1033

Explain the creation and execution of a user-defined function in the sql server?

1045

What is the order by used for?

1016

What is measure group, measure? : sql server analysis services, ssas

1001

What are group functions in query statements in ms sql server?

999

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

970

if no size is defined while creating the database, what size will the database have? : Sql server administration

996

How many replicas are maintained for each SQL Azure database?

142

Explain few examples of RDBMS?

1035

What is the difference between Stored Procedures and triggers?

1074

‘Order by’ is not allowed in a view how can you sort information from a view?

1076

What is a trigger and its types?

979

how would you improve etl (extract, transform, load) throughput?

1023

What is 2nf normalization?

1014

What is sparse columns of sql server 2008?

1043

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