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 2682

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,

1129

What is order of B+tree?

HCL,

1106

Explain about Normalization?

Infosys,

1057

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

Hexaware,

1311

Explain about Joins?

Infosys,

984

What are the purpose of Normalisation?

HCL,

1048

Difference between group by clause and having clause in SQL?

Flextronics,

970

What are the types of subscriptions in SQL Server replication?

HCL,

1026

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

Informatica,

1005

What are the characteristics of modern DBMS?

Ericsson,

1086

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

MCN Solutions,

1214

Define DML and DCL statements?

Hexaware, NIIT,

1 1653

Un-Answered Questions { SQL Server }

How to set database to be read_only in ms sql server?

1001

Where in ms sql server is ’100’ equal to ‘0’?

1078

Which are the olap features?

953

What is sub-query in sql server?

1199

How to deploy the Report?

138

What is a benefit of using an after insert trigger over using a before insert trigger?

981

in the physical file layout, where should the transaction log be stored in relation to the data file?

990

Can you get second highest salary from the table?

959

what does the automatic recovery do? : Sql server administration

1014

Would you store your query in a ssrs report or a database server? State the reason why?

152

How many replicas are maintained for each sql azure db?

124

Write the SQL query to drop, truncate and delete table.

966

Define right outer join in sql server joins?

1040

Mention the differences between having and where clause.

1055

What are joins in sql and what are the different types of joins?

1009

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