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?

1076

What is self contained scalar sub query?

1014

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

1047

Find nth lowest salary or get nth lowest salary?

1081

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

1076

What is instead of dml trigger?

1054

Explain different types of self contained sub query?

1105

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

1025

Explain relational data?

968

What are the different normalization forms?

1162

Explain primary key, foreign key and unique key?

1024

What is clr ddl trigger?

1034

How to stop log file growing too big?

1059

How to enable/disable indexes?

1123

Difference between Inner vs outer joins?

986

Un-Answered Questions { SQL Server }

How to create a new login name in ms sql server?

1107

What is difference between clustered index and non clustered index?

1122

How to set database to be single_user in ms sql server?

1080

Difference between report and query parameter. Why do we need different type of parameter?

1011

What is the usage of the sign function?

1193

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1180

How to connect to a sql server using odbc_connect()?

1203

What is user-defined functions? What are the types of user-defined functions that can be created?

1080

How do we know if any query is retrieving a large amount of data or very little data?

1032

What do you understand by coalesce in sql server?

1127

Explain about local stored procedure?

1028

How many databases Microsoft SQL server provides?

1153

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

123

What does it mean to manipulate data?

1050

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

1014

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