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 is sql server replication? : sql server replication

1041

What is the difference between push and pull subscription? : sql server replication

1279

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1036

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1260

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1124

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

What are different replication agents and what's their purpose? : sql server replication

1057

Does a specific recovery model need to be used for a replicated database? : sql server replication

1014

How to perform backup for certificates in sql server? : sql server security

1148

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1112

What is application role in sql server database security? : sql server security

1121

How to enforce security in sql server? : sql server security

1162

What is the use of builtinadministrators group in sql server? : sql server security

1110

What are the security related catalog views? : sql server security

994

What options are available to audit login activity? : sql server security

1202

Un-Answered Questions { SQL Server }

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

1270

How many categories of functions based their return modes?

1154

What is the difference function and stored procedure?

1117

Explain DBCC?

1018

How to query multiple tables jointly?

1044

Can we insert data if clustered index is disabled?

989

Call by value and call by reference in procedure and function, with NOCOPY.

1351

What is raiseerror? What is raiseerror?

1195

What are the different types of lock modes in sql server 2000?

997

Explain what you mean by 3 tier architecture.

1128

In which format does an image save in SQL Server database ?

1060

How to add additional conditions in SQL?

1071

Explain Normalization and DE normalization

1160

How self join is different from outer join?

1182

what happens on checkpoint? : Sql server database administration

1158

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