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?

1078

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

914

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?

1326

How to find the second highest salary of an employee?

1179

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

1191

How to make a remote connection in a database?

977

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

1231

Explain the first normal form(1nf)?

1023

What is a non-clustered index?

998

Explain the relational database management system (rdbms)?

1097

What is checkpoint in sql server?

1157

What is normalization and denormalization in sql server?

1014

Explain “not null constraint” in sql server?

1028

Explain indexing and what are the advantages of it?

1028

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

1223

Un-Answered Questions { SQL Server }

What are the instances when triggers are appropriate?

979

Explain the first normal form(1nf)?

1023

How do you delete duplicate rows in sql server?

955

Explain how many normalization forms?

1031

What do you mean by subquery?

1087

Can you explain various data region available in ssrs with their use?

976

explain how to create a new schema in a database? : Sql server database administration

1106

What are commit and rollback in sql?

1123

What is the use of sign function?

1124

Why main is user defined function?

1010

Relational calculus is what type of language?

1036

What are Spatial data types in SQL Server 2008

1020

What is join query?

893

Can sub report data source be different from that of the parent report?

143

Mention the differences between substr and charindex in sql server.

1050

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