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 2773

What are the types of database recovery models?

HCL,

1187

What is function of CUBE ?

HCL,

1076

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

Flextronics,

1181

What is order of B+tree?

HCL,

1152

Explain about Normalization?

Infosys,

1122

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

Hexaware,

1364

Explain about Joins?

Infosys,

1035

What are the purpose of Normalisation?

HCL,

1095

Difference between group by clause and having clause in SQL?

Flextronics,

1026

What are the types of subscriptions in SQL Server replication?

HCL,

1104

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

Informatica,

1055

What are the characteristics of modern DBMS?

Ericsson,

1140

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

MCN Solutions,

1272

Define DML and DCL statements?

Hexaware, NIIT,

1 1738

Un-Answered Questions { SQL Server }

How to execute stored procedure in select statement sql server?

1112

What are statistics?

1050

How do I create a stored procedure in sql server?

1095

What is #table in sql server?

1096

Do you think BCNF is better than 2NF & 3NF? Why?

1338

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2414

What is user-defined scalar function?

1009

How do you Implement SSIS Packages in your Project?

1986

Which tcl commands are available on the sql server?

1139

What is history table in sql server?

1028

How much is a sql server license?

1009

Explain hostprotectionattribute in sql server 2005?

1075

What is failover clustering overview?

1140

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1168

what do you understand by change data capture?

1077

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