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

What are sql azure firewall rules?

106

What do you mean by data manipulation language?

1063

Explain sql server authentication modes?

1186

List out some of the requirements to set up a sql server failover cluster?

1074

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

1166

Explain “row_number()” in sql server with an example?

1053

List out the different types of locks available in sql server?

1025

What is a view in sql?

1021

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1267

What are the different types of subquery?

1200

Can sql servers link to other servers like oracle?

894

Why we use the openxml clause?

1055

Can one drop a column from a table?

1067

What are the main differences between #temp tables and @table variables and which one is preferred?

1134

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

999

Un-Answered Questions { SQL Server }

What is the contrast between sql and pl/sql?

1198

What are the pre-defined functions in the sql server?

1182

In which sql server version report builder introduced?

150

Explain subquery and state its properties?

1089

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

1180

What is cursor in ms sql server?

1201

What are the benefits of normalization?

1156

When would you use a before or after trigger?

955

Explain different types of Normalization.

1901

What are the disadvantages of indexes?

1154

Define master database?

1141

What is the difference between varchar and nvarchar?

985

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1043

What is table-valued sub query?

1026

Can group functions be used in the order by clause in ms sql server?

1067

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