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 an inner join?

1038

What is an example of a primary key?

1037

What is proper subset of candidate key?

1039

What is the concept of optimization?

1105

What is the benefit of normalization?

1129

What is the full meaning of dml?

998

What is optimization and its types?

1037

What is a ddl statement?

960

What is difference between equi join and inner join?

1033

What is the most common type of join?

1036

What is a periodical index?

973

What is abstracting periodical?

986

What is mean by candidate key?

1059

What is purpose of normalization?

998

What is the difference between composite index and covering index?

1005

Un-Answered Questions { SQL Server }

What is the difference between dbcc indexdefrag and dbcc reindex?

1031

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1247

What do you understand by replication in sql server?

1124

Describe in brief sql server monitoring ways.

1095

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

1199

How to create a dynamic cursor with the dynamic option?

1099

Explain what is the use of custom fields in report?

957

What is difference between materialized view and view?

950

Explain the difference between HTTP and HTTPS in database?

1091

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2411

what is a sub-report?

146

What is difference in performance between insert top (n) into table and using top with insert?

1116

What are different types of subquery?

1302

How can you list all the table constraints in a database?

980

What is BCP? When does it used in sql server 2012?

1102

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