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

Why is DML provided?

Ernst Young, Thomson Reuters,

1 2680

What are the types of database recovery models?

HCL,

1112

What is function of CUBE ?

HCL,

1033

What is RAID? What are the different types of RAID configurations?

Flextronics,

1128

What is order of B+tree?

HCL,

1105

Explain about Normalization?

Infosys,

1054

What are triggers? How do you invoke a trigger on demand?

Hexaware,

1308

Explain about Joins?

Infosys,

983

What are the purpose of Normalisation?

HCL,

1048

Difference between group by clause and having clause in SQL?

Flextronics,

968

What are the types of subscriptions in SQL Server replication?

HCL,

1023

Â Explain what is sql override for a source taLle in a mapping?

Informatica,

1003

What are the characteristics of modern DBMS?

Ericsson,

1085

How to change the system date and time from SQL Plus Terminal ?

MCN Solutions,

1213

Define DML and DCL statements?

Hexaware, NIIT,

1 1651

Un-Answered Questions { SQL Server }

What happens when converting big values to numeric data types?

1122

What is catalog views?

1064

What is transaction server distributed transaction?

1049

What is ssl in sql server?

1069

How can you list all the table constraints in a database?

934

What it means to be triggered?

989

Explain transaction server consistency?

962

What is user-defined function?

964

What do you understand by coalesce in sql server?

1066

what is database replicaion? : Sql server database administration

1182

What according to you is the difference between mysql and sql server performance?

1079

Explain intellisense for query editing

1024

What are date and time data types in ms sql server?

1084

Can we use pragma autonomous_transaction in trigger?

954

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2012

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