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

1037

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

1275

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

1030

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

1257

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

1122

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

1053

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

1010

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

1142

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

1110

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

1119

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

1161

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

1105

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

989

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

1196

Un-Answered Questions { SQL Server }

What is intellisense?

1098

What is optimistic concurrency?

1091

Describe in brief sql server monitoring ways.

1096

List the types of recovery model available in sql server?

970

How to add additional conditions in SQL?

1066

What is the user of Primary key?

1029

Can I work with several databases simultaneously? : sql server management studio

1029

How to declare a cursor with "declare ... Cursor" in ms sql server?

1090

What are the types of processing and explain each? : sql server analysis services, ssas

1205

Does sql server 2016 have ssms?

1004

What is change data capture (cdc) in sql server 2008?

1078

Explain security with sql azure?

186

What is BCP? When does it used in sql server 2012?

1105

What is dirty read?

1135

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1795

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