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

987

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

980

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

1079

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

1019

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

1057

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

950

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

1153

Un-Answered Questions { SQL Server }

How do I port a number to sql server?

1038

Explain transaction server auto commit?

1040

When cursors are useful?

1104

What are information schema views?

987

How many primary keys are possible in a table?

926

What is the size of transaction log file?

931

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

How to get the definition of a view out of the sql server?

987

Where actually sql azure database is hosted?

163

What is the difference between clustered and a non-clustered index?

1028

How to change a login name in ms sql server?

1089

What is molap and its advantage? : sql server analysis services, ssas

986

What are some examples of schemas?

980

What are different types of views?

948

How to add a new dsn with the odbc driver for sql server?

1060

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