Sql server interview questions

Question 1 What is normalization

Question 2 What are different types of normalization

Question 3 What is denormalization

Question 4 What is candidate key

Question 5 What are the different types of joins

Question 6 What are indexes?

Question 7 What is the difference between clustered and nonclustered indexes

Question 8 What are data regions?

Question 9 What is the main difference between a matrix report item and a table report item?

Question 10 Difference between logical page an physical page in ssrs?

Question 11 Describe the role of encrpytion key in report server configuration manager?

Question 12 Name and describe few console utilities for ssrs?

Question 13 What is an error-tolerant index

Question 14 Define ssis and the main cases where it is used

Question 15 Is there any way to achieve parallelism in ssis

Question 16 What is integration services import / export wizard

Question 17 What are prime components in integration services

Question 18 What is dtutil and dtexec used for

Question 19 What is execution tree in ssis

Question 20 What is logical or conditional precedence in ssis

.net interview questions

Asp.net interview questions

C# interview questions

Vb.net interview questions

Ado.net interview questions

Ajax interview questions

Wcf interview questions

Wpf interview questions

.net threading interview questions

.net remoting and webservices interview questions

.net caching interview questions

.net oops interview questions

Sharepoint interview questions

Jquery interview questions

Silverlight interview questions

Linq interview questions

Wwf interview questions

Java interview questions

Sql server interview questions

Ssis interview questions

Ssrs interview questions

Data warehousing interview questions

Data mining interview questions

Oracle interview questions

Php interview questions

Design patterns interview questions

Uml interview questions

Mcpd dumps

Pmp practice tests

Reader's opinions -