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 2786

What are the types of database recovery models?

HCL,

1 1209

What is function of CUBE ?

HCL,

1 1093

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

Flextronics,

1 1199

What is order of B+tree?

HCL,

1 1164

Explain about Normalization?

Infosys,

1 1135

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

Hexaware,

1 1380

Explain about Joins?

Infosys,

1 1043

What are the purpose of Normalisation?

HCL,

1 1103

Difference between group by clause and having clause in SQL?

Flextronics,

1 1033

What are the types of subscriptions in SQL Server replication?

HCL,

1 1124

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

Informatica,

1 1065

What are the characteristics of modern DBMS?

Ericsson,

1 1157

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

MCN Solutions,

1 1296

Define DML and DCL statements?

Hexaware, NIIT,

1 1762

Un-Answered Questions { SQL Server }

What is the difference between for xml raw and for xml auto?

1095

Can one drop a column from a table?

1075

How to connect php with different port numbers?

1159

How do I find query history in sql server?

1005

Why and when do stored procedure recompile?

1042

How do I start sql server 2017?

1001

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

How to convert numeric expression data types using the cast() function?

1135

Where can you add custom error messages to sql server?

1190

How to rebuild the master database?

1148

What is sql or structured query language?

1206

What are wait types?

1219

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177

What are the kinds of subquery?

1087

What is the primary use of the model database?

1141

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