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?

950

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?

1384

How to find the second highest salary of an employee?

1221

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

1276

How to make a remote connection in a database?

1022

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

1277

Explain the first normal form(1nf)?

1077

What is a non-clustered index?

1045

Explain the relational database management system (rdbms)?

1162

What is checkpoint in sql server?

1215

What is normalization and denormalization in sql server?

1063

Explain “not null constraint” in sql server?

1090

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 }

Can we use having clause without group by?

1030

What is an indexed view?

1007

What is database white box testing?

1176

What is function of master database?

116

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1096

How do you open a cluster administrator?

1096

What is the sql server 2000 version number?

1147

What is the syntax for encrypting a column in SQL Server?

1174

What is tempdb database? : SQL Server Architecture

1256

What is the log shipping?

1063

What is similarity and difference between truncate and delete in sql?

1153

What is the difference between ‘having’ clause and a ‘where’ clause?

1086

What is collation sensitivity?

1134

How to handle error or exception in sql?

1036

What is the difference between a function and a trigger?

1123

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