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

984

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

1216

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

979

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

1216

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

1077

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

1093

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

1016

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

961

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

1092

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

1049

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

1055

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

1104

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

1048

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

949

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

1152

Un-Answered Questions { SQL Server }

What is a database in ms sql server?

1057

How do users use Report Builder with SQL Server data sources?

155

Write an SQL query to obtain the 2nd highest salary.

1078

How you can get the list of largest tables in a database?

1014

What is measure group, measure? : sql server analysis services, ssas

1013

What is sql collation?

1207

What are the new features are introduced in sql server 2012 reporting services?

149

How to delete an existing row with delete statements in ms sql server?

1092

What is the purpose of floor function?

1039

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

923

What are the different SQL Server Versions you have worked on?

1004

What is the use of keyword with encryption.

1028

How do you check sql server is up and running?

1001

How to create a trigger for insert only?

1038

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1006

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