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 the significance of master, tempdb and model databases?

1128

Explain alternate key, candidate key and composite key in sql server?

947

Due 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?

1381

How to find the second highest salary of an employee?

1221

What is the main difference between ‘between’ and ‘in’ condition operators?

1272

How to make a remote connection in a database?

1020

Can we write a distributed query and get some data which is located on other server and oracle database?

1275

Explain the first normal form(1nf)?

1076

What is a non-clustered index?

1044

Explain the relational database management system (rdbms)?

1161

What is checkpoint in sql server?

1214

What is normalization and denormalization in sql server?

1061

Explain “not null constraint” in sql server?

1089

Explain indexing and what are the advantages of it?

1070

Can we hide the definition of a stored procedure from a use?

1296

Un-Answered Questions { SQL Server }

how to create “alternate row colour”?

152

What are the different types of locks in the database?

972

What do you understand by integration services in sql server?

999

Can I run multiple instances of sql server 2000 at the same time on one computer?

1119

How to change parameter value inside the report?

169

What is view in sql?

950

If user is owning any SQL Objects, can we drop that user

2128

is there a column to which a default can't be bound? : Sql server database administration

1050

what is database replication? : Sql server database administration

1128

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1094

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1125

What are user-defined functions (udfs) in sql server?

1048

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

176

Can truncate be rolled back?

989

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1050

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