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 are the different types of sub-queries?

1090

How to choose all records from the table?

1104

What is an index. What are the types?

1162

What happens on checkpoint?

1069

Distinguish between nested subquery and correlated subquery?

1114

Define synonym?

1222

What are the different ways you can create databases in sql server?

1155

How many null values we can have in a unique key field in sql server?

1011

How would we use distinct statement? What is its use?

1123

What are scalar functions in sql?

1208

What are distinctive joins find as a part of sql?

1001

What are diverse clauses that form a part of sql?

1111

Define primary key?

1200

What is the distinction amongst delete and truncate?

1111

What are the diifferences between the ms sql server vs mysql?

1236

Un-Answered Questions { SQL Server }

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1095

Do you know clustered and non-clustered index?

1021

How to compare the top two records using sql?

1414

Explain transaction server distributed transaction?

1039

How to connect ms access to sql servers through odbc?

1070

What is 2nf normalization?

1088

How do I start sql server agent automatically?

1027

What are the disadvantages of using querystrings to send data from one page to another?

1071

Write a SQL command to insert and update only a particular field?

1190

What is right outer join in sql server joins?

1220

Can we add an identity column to decimal datatype?

1042

How can windows applications connect to sql servers via odbc?

1179

How do I perform an unattended install of sql server 2000?

1138

What is plan freezing?

1013

What is attribute? : sql server analysis services, ssas

1069

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