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

976

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

1209

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

976

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

1207

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

1074

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

1083

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

1006

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

956

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

1086

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

1042

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

1055

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

1101

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

1039

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

943

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

1145

Un-Answered Questions { SQL Server }

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1024

Characterize join and name diverse sorts of joins?

964

How to get a list of columns using the "sys.columns" view in ms sql server?

954

How to check parameter value in stored procedure sql server?

966

What is the datatype of rowid?

913

What is meant by referential integrity?

1006

What is a functions and types in sql server?

1085

How is SQL Azure different than SQL server?

223

Explain the difference between delete,drop and truncate in SQL Server?

1091

What is mssql?

980

How to remove duplicate rows from table except one?

1001

How each E-R model constructs can be mapped to the relational model?

993

How much space does sql server 2016 take?

952

How to modify an existing user defined function?

1099

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

944

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