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 does top operator do?

1020

What is self contained scalar sub query?

974

How can I get data from a database on another server?

996

Find nth lowest salary or get nth lowest salary?

1029

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1025

What is instead of dml trigger?

1004

Explain different types of self contained sub query?

1038

What is the difference between grant and with grant while giving permissions to the user?

963

Explain relational data?

924

What are the different normalization forms?

1111

Explain primary key, foreign key and unique key?

993

What is clr ddl trigger?

966

How to stop log file growing too big?

1014

How to enable/disable indexes?

1068

Difference between Inner vs outer joins?

950

Un-Answered Questions { SQL Server }

What is after dml trigger?

1016

How connect excel to sql server?

996

How to read data in a table with "select" statements?

967

What is mssql?

985

What are the differences between stored procedure and view in sql server?

1248

What are rows and columns?

1019

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

977

What is mean by candidate key?

1011

What are different types of roles provided by ssrs?

150

How to delete an existing database user?

1017

What is save transaction and save point?

1202

Explain what is log shipping?

1136

What language is sql server written in?

1033

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2504

What do you mean by SQL injection attack?

1066

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