Tuesday 31 july 2012 2 31 /07 /Jul /2012 15:51

 


s1-copy-1.jpg

 

What is normalization and what are the benefits of the same?

What is 1st normal form, second normal form and 3rd normal form?

What is denormalization?

What is the difference between OLTP and OLAP system?

For what kind of systems is normalization better as compared to denormalization?

What are Facts, Dimension and Measures tables?

What is the difference between star schema and snow flake design?

 

 

Overview



This is an interesting topic and yes it’s the most discussed one when it comes to SQL Server interviews.

 

s2-copy-1.jpg

 

In SQL Server interviews database design conversation goes in to two wide discussions one is Normalization and the other is de-normalization.

 

So in normalization section interviewer can ask you questions around the 3 normal forms i.e. 1st normal form, second normal form and 3rd normal form. This looks to be a very simple question but you would be surprised to know even veteran database designers forget the definition thus giving an impression to the interviewer that they do not know database designing.

 

Irrespective you are senior or a junior everyone expects you to answer all the 3 normal forms. There are exceptions as well where interviewer has asked about 4th and 5th normal form as well but you can excuse those if you wish. I personally think that’s too much to ask for.

 

When it comes to database designing technique interviewer can query the other side of the coin i.e. de-normalization. One of the important questions which interviewers can query is around Difference between de-normalization and normalization. The expectation from most of the interviewers when answering the differences is from the perspective of performance and type of application.

 

As people discuss ahead there is high possibility of getting in to OLTP and OLAP discussions which can further trigger discussions around database designing techniques Star and Snow flake schema.

 

See the following video on SQL server interview question: - Difference between unique and primary keys?

 

 

 

What is normalization and what are the benefits of the same?


It’s a database design technique to avoid repetitive data and maintain integrity of the data.

 

Note: - After that sweet one line, I can bet the interviewer will ask you to clarify more on those two words repetitive and integrity word.

 

Let’s first start with repetitive. Let’s say you have a simple table of user as shown below. You can see how the city is repeated again and again. So you would like to improve on this.

 

s3-copy-1.jpg

 

So to solve the problem, very simple you apply normalization. You split that repetitive data in to separate table (city master) and put a reference foreign key as shown in the below figure.

 

s4.jpg

 

Now the second word “Data integrity”. “Data integrity” means how much accurate and consistent your data is.

 

For instance in the below figure you can see how the name of the country is inconsistent. “Ind” and “India” means the same thing, “USA” and “United States” means the same the thing. This kind of inconsistency leads to more complication and problems in maintenance.

 

s5.jpg

 

 

One of the most important thing in technical interviews like SQL , .NET , Java etc is that you need to use proper technical vocabulary. For example in the above answer the word “Data integrity” attracts the interviewer than the word “Inaccurate”. Right technical vocabulary will make you shine as compared to people who use plain English.


See the following video on SQL server interview question: - Difference between Union and Union All?

 

 


What is 1st normal form, second normal form and 3rd normal form?


Its surprising that many experienced professionals cannot answer this question. So below is simplified one liner’s for each of these normal forms.

 

  • First normal form is all about breaking data in to smaller logical pieces.
  • In Second normal form all column data should depend fully on the key and not partially.
  • In Third normal form no column should depend on other columns.


s6.jpg

 

For in-depth explanation you can also see the video :- Can you explain First, Second & Third Normal forms in database? provided in the DVD.


 

What is denormalization?

 

Denormalization is exact opposite of normalization. Normalization is good when we want to ensure that we do not have duplicate and inconsistent data. In other words when we want to do operational activities like insert, update, delete and simple reports normalization design is perfectly suited. Putting in other words when data comes in to the system a normalized design would be the best suited.

 

But what if the we want to analyze historical data, do forecasting, do heavy calculations etc. For these kinds of requirements normalization design is not suited. Forecasting and analyzing are heavy operations and with historical data it becomes heavier. If your design is following normalization then your SQL needs to pull from different tables making the select process slow.

 

Normalization is all about reducing redundancy while denormalization is all about increasing redundancy and minimizing number of tables.

 

s7.jpg

 

In the above figure you can see at the left hand side we have a normalized design while in the right hand side we have denormalized design. A query on the right side denormalized table will be faster as compared to the left hand side because there are more tables involved.

 

You will use denormalized design when your application is more meant to do reporting, forecasting and analyzing historical data where read performance is more important.

 

See the following SQL Server interview question video on Difference between subquery and co-related queries ?

 

 


What is the difference between OLTP and OLAP system?


Both OLTP and OLAP are types of IT systems.OLTP (Online transaction processing system) deals with transactions ( insert, update , delete and simple search ) while OLAP (Online analytical processing) deals with analyzing historical data, forecasting etc.

 

Below is a simple table which chalks out the differences.

 

  OLTP OLAP
Design Normalized. (1st normal form, second normal form and third normal form). Denormalized (Dimension and Fact design).
Source Daily transactions. OLTP.
Motive Faster insert, updates, deletes and improve data quality by reducing redundancy. Faster analysis and search by combining tables.
SQL complexity Simple and Medium. Highly complex due to analysis and forecasting.

 

 

For what kind of systems is normalization better as compared to denormalization?


Normalization is best suited for OLTP systems (faster transactions) while denormalizations are best suited for OLAP systems (faster queries and analysis).

 

 

What are Facts, Dimension and Measures tables?


The most important goal of OLAP application is analysis on historical data. The most important thing in any analysis are “NUMBERS”. So with OLAP application we would like to get those numbers , forecast them, analyze them for better business growth. These numbers can be total sales, number of customers etc.

 

These numbers are termed as “Measures” and measures are mostly stored in “Fact” tables. “Dimension” describes what these measures actually mean. For example in the below table you can see we have two measures 3000 units and 1500 $. One measure is “ProductWiseSales” and the other measure is “AgewiseSalary’.

 

Dimensions are stored in dimension table.

 

Dimension Measures
ProductWiseSales 3000 units
AgeWiseSalary 1500 $

 

Watch the following awesome video on SQL Server interview questions: - Find the second highest from a table?

 

 


What is the difference between star schema and snow flake design?


Star schema consists of fact and dimension tables. The fact tables have the measures and dimension tables give more context to the fact tables.

 

In the below figure “Star design” you can see we have four dimension tables and each one of them are referencing the fact tables for measure values. The references between dimension and fact tables are done using simple foreign key relationships.

 

s8.jpg

 

Figure: - Star design


Snow flake design is very much similar to star design. The exception is the dimension table. In snow flake dimension tables are normalized as shown in the below figure “Snow flake design”. The below design is very much similar to the star design shown previously but the products table and vendor tables are separate tables.

 

The relationship is more of a normalized format. So summing in other words Star design is pure denormalized design while snow flake can have normalized dimension tables.

 

s9.jpg

 

Figure: - Snow flake design


  Snowflake Schema Star Schema
Normalization Can have normalized dimension tables. Pure denormalized dimension tables.
Maintenance Less redundancy so less maintenance. More redundancy due to denormalized format so more maintenance.
Query Complex Queries due to normalized dimension tables. Simple queries due to pure denormalized design.
Joins More joins due to normalization. Less joins.
Usage guidelines If you are concerned about integrity and duplication. More than data integrity speed and performance is concern here.

 

See the following video on SQL server interview question: - Why do we need denormalization in SQL Server?

 

 

See for more stuffs on SQL Server Interview question

 

Regards,

 

Click to view more from author's on SQL Server Interview question

 

Also buy SQL Server interview question book from here.

By Shivprasad koirala
Enter comment - View the 1 comments
Home

Important .NET and C# interview questions and answers

.Net interview questions: - Explain why it is not preferred to use finalize for clean up?

.Net interview questions: - Show the five levels in CMMI?

.NET interview questions and answers: – Which is the best place to store connection string in .NET projects?

C# interview questions and answers: – Explain the use of Icomparable in c#?

C# interview questions: - How can we check which rows have changed since dataset was loaded?

C# interview questions and answers: - Can you write a simple c# code to display Fibonacci series?

.NET interview questions and answers: - What is difference betweenIcomparable VS Icomparer ?

C# and .NET interview question: -What is short circuiting in C#?

C# and .NET interview question: - What are symmetric and asymmetric algorithms?

Important c# and .NET interview question on object pooling and Gridview events?

.NETinterview questions and answers: – Will the finally run in this code?

How to prepare for c# and .NETinterviews?

C# and .NET Interview questions: - What is Thread.Join () in threading?

.NET Interview questions and answers: -What is serialization and deserialization in .NET?

C# and .NET interview question: - What is hashing?

c# and .NET interview question:- what connects dataset and data source ?

.Net interview questions and answers: - What is the difference between “Web.config” and “Machine.Config”?

.NET interview questions and answers: - What is TPL?

.NET Interview questions and answers: -What are different access modifiers?

.NET and c# Interview Question and answers: – If we want to update interface with new methods, what is the best practice?

 MVC ( Model view controller) interview questions and answers      

ASP.NET Application and Page Life Cycle 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage) 

 6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

 

 

 

 

MVC Interview questions videos

Viewdata,viewbag,tempdata

MVC asynch controllers

 

 

 

MVC Interview questions and answers Article

 

(Model view controller)MVC Interview questions and answers

MVC interview questions with answers video: – What is Web API how to implement the same?

ASP.Net MVC  4 interview questions with answers: - What is Bundling and minification in Model view controller ?

MVC interview questions with answers :- Is it possible to return values instead of Actionresults?

MVC interview questions with answers :- What are the actionresults available in MVC?

MVC interview questions with answers:-Html.PartialvsHtml.RenderPartialvsHtml.RenderPage in MVC

MVC ASP.NET INTERVIEW QUESTIONS WITH ANSWERS :- WHAT IS THE DIFFERENCE BETWEEN VIEWSTATE VS VIEWDATA ?

MVC vs ASP.NET ( MVC Interview question with answers )?

How can we detect that a MVC controller is called by POST or GET ? ( ASP.NET MVC Interview questions with answers)

What are the different ways by which you will get Form Data in controller? ( MVC Interview questions with answers)

What is the difference between Presenter and Controller in MVC?(MVC interview questions with answers)

Learn MVC (Model view controller) Step by Step in 7 days – Day 4

MVC Interview questions and answers PDF

MVC interview questions with answers

ActionResult vs. View() vs. ViewResult :- MVC interview questions with answers

Explain Areas in MVC?( MVC interview questions with answers)

Can you explain the purpose of ViewModel in MVC?( ASP.NET MVC Interview questions with answers)

ASP.NET MVC interview questions: - What are Filters in MVC?

What are areas in MVC?( MVC Interview questions with answers)

Explain the concept of View Model in MVC?

Exception Handling in MVC

Explain MVC application life cycle?


100 MVC Interview question PDF download released , Enjoy


Learn Microsoft Business intelligence step by step – Day 1


Can you create TempBag just like ViewBag?( MVC Interview questions)

 

 

 


WCF Interview questions videos

 

overloading in WCF

WCF fault exceptions ?

 

 

 

 

WPF Interview question with answers videos

 

Why WPF and compare WPF with Winforms ?

 

 

C# Interview Questions & Answers Article

 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage)

6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

C# (Csharp) interview questions and answers: – What are indexers in .NET?

C# OOP interview questions and answers: - I do not want to implement all the interface methods?

C# design pattern (UNIT of Work Design Pattern)

C# design pattern interview questions – What is Dependency injection ?

C# interview questions and answers: - What is the difference between “==” and .Equals()?

How questions are asked in c# interviews?

C# design pattern interview question: - DI vs IOC

8 important C# Interview questions on IL code, JIT, CLR, CTS, CLS and CAS

What is the difference between Reflection and Dynamic in C#?

C# and .NET interview question: – When should we use Structure as compared to classes
?

C# REST interview questions with answers asked in Polaris Hydrebad

c# threading interview questions :- Parallel.ForEach vs Task.Factory.StartNew

C# circular dependency interview questions with answers.

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

C# and .NET interview questions with answers: - How can we mark a method as deprecated?

C# INTERVIEW QUESTIONS WITH ANSWERS: - HOW TO ASSIGN MULTILINE STRING IN VISUAL STUDIO?

What is cyclomatic complexity (C# testing interview questions with answers)?

Define code coverage? (C# unit testing interview questions with answers)

Can you talk about Abstraction and Encapsulation in detail ? ( .NET, c# and OOP interview questions with answers )

Can you explain a practical example of virtual and Override? ( C# OOP interview questions with answers )

Can you explain class and object in real time scenario? ( C# and .NET OOP Interview questions with answers)

What is code digger ? ( C# visual studio interview questions with answers)

C# Lazy loading interview questions with answers

What is eager loading in c# ( C# eager loading interview questions with answers)?

Can you explain the term concurrency? (C# Interview questions with answers)

10 important C# Constructor and destructor interview questions

3 important c# Partial class interview questions with answers

Change Functionality without changing function( C# Architecture interview question with answers)?

What is ENUM and what are the benefits of using it (ENUM C# Interview Question 1)?

How can we loop through ENUM values( C# ENUM Interview questions with answers)?

What is the difference between Connection Timeout and Command Timeout?( C# ADO.NET Interview questions with answers)

How you differentiate Shadowing with Overriding? (C# overriding interview questions)

C# date and time interview question with answers

Explain the difference between early binding and late binding? ( C# interview questions with answers)

How can we restrict types in generics ?( C# generic interview questions)

What are generics, Delegates and Generic delegates ( C# interview questions)?

How can we convert JSON string in to c# object?(  C# JSON interview questions)

C# and .NET interview questions asked in TCSwalkin.

C# and .NET interview questions on Coalescing operator.

String vs string ( C# interview questions with answers)

Explain SOLID principles (C# Architecture interview questions)?

C# and .NET interview questions around Read only and Constant

C# Architecture interview questions with answers

C# Mock testing interview questions and answers: – What is Mock testing and how can we implement Mocking?

Write a simple regex for email validation? (C# interview questions with answers)


C#.NET interview questions: - What is the use of “Yield” keyword? Mention atleast one practical scenario where it can be used?

C#.NET interview questions: - What is the difference between Build Vs Rebuild Vs Clean solution menu? What is the difference “Rebuild” and if you do “Clean” + “Build”?

C# and .NET interview questions around JIT and NGEN


What is the difference between throw vs throw ex ?( C# Interview questions with answers)

 

 

Algorithm Interview Questions


Algorithm interview questions and answers: – Can you write code for bubble sort algorithm?

Algorithm interview questions and answers: – What is inserted sort algorithm?

SQL INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

SQL Server Interview Questions & Answers Article

SQL Server interview questions and answers: - What is HID data type in SQL Server ?

SQL Server interview questions with answers: – How to get the top record without using max, top and order by keyword?

SQL Server interview questions with answers :- If you wish to store financial values which SQL Server data type is more suitable ?

SQL Server interview questions and answers: – What is the difference between Candidate Key, Primary Key, and Alternate Key

SQL Server interview questions with answers :- What are Indexes in Sql Server?

How to sort interactively using SSRS? (SQL Server reporting services interview questions)

How to do conditional formatting in SSRS? (SQL Server reporting services interview questions with answers)

WHAT IS NORMALIZATION AND EXPLAIN 1NF 2NF AND 3NF IN SIMPLE WORDS? SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

 

When you will use inner join and when you will use outer join? SQL Server interview questions with answers

 

Do you know anything about Temporary procedures in SQL?( SQL Server interview questions with answers)

 

4 SQL Server interview questions with answers on TempTb

 

Are full outer join and Cross join are same? ( SQL Server interview questions with answers)

 

Delete duplicate records: - SQL Server interview questions with answers

 

4 most asked  SQL queries during SQL Serverinterview’s

 

How Temporary tables are different from normal tables and what are its types ?( SQL Server interview questions with answers)

 

SQL Server interview Questions on JOIN’s

 

SQL Server interview questions: - How can you increase SQL performance?

 

SQL Server interview questions: - What problem you face if locking is not implemented?

 

Can we insert NULL’s in to UNIQUE key ? ( SQL Server  interview questions with answers)

 

Explain Normalization?(SQL Server Interview questions with answers)

Temp variablesVS Temp tables(SQL Server interview questions)

 

 

 

 

.NET INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

.NET interview questions and answers: - How to reverse a string in .NET ( DotNet)?

.NET interview questions and answers: - What is the use of Click Once?

.NET interview questions and answers: - Will the below codes create new instances?

C# and .NET interview questions with answers – What is Nuget?

Dependency injection (DI) VS Inversion of Control (IOC)

.NET interview questions with answers: - What is the difference between Reflection and Dynamic?

Five Great .NET Framework 4.5 Features

ASP.NET MVC 4 interview questions with answers: - What is the use of “AllowHTML” and “ValidateInput” attributes?

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

.NET interview questions with answers: – Can we use events without delegates ?

.Net Interview question Edition 6 is available now.

.NET interview questions with answers: – What’s the difference between catch with parameter and catch without parameter?

.NET interview questions : - What is the use and difference between “IS” and “AS” keyword?

.NET interview questions with answers: - Build solution VS Rebuild solution VS Clean solution

HTML 5 interview questions with answers for LocalStorage and SessionStorage

.NET 4.0 interview questions with answers: – What are code contracts?

What are portable class libraries? ( .NET interview questions with answers)

How to loop through ENUM using C# (.NET interview questions with answers)?

What are transactions in C#? (.NET interview questions with answers)

What are ACID Properties( .NET Interview questions with answers)?

.NET interview questions: – What are the areas that need to be concentrated for senior(9+ years experience)persons in .NET technologies?

.NET interview questions: - Explain real time scenarios in Factory Pattern, Abstract Pattern, Singleton, WCF and REST services

What is the difference between IS A and Can a Relationship?( .NET Interview questions with answers)

What is the use of ENUM Flags(.NET Enum Interview question 2)?

What is the difference between .Net,C#, Asp.net, Asp.net Web Forms and Asp.net MVC and MVC?( C# and ASP.NET Interview questions)

ADO.NET interview questions: - Explain in detail the fundamental of connection pooling?

.NET interview questions: – Can you explain generics in .NET?

What are Properties and methods ? ( .NET OOP Interview questions with answers)

What’s the first step you take for implementing any of Design Pattern?( .NET  Design pattern interview questions with answers)

.NET interview questions: - What are different types of JIT?

ADO.NET Interview Question: - What are the major differences between classic ADO and ADO.NET?

.NET interview questions: – What is the difference between Reflection and Dynamic?

What is the Use of interfaces?( .NET Interview questions with answers)

.NET interview questions: - What role did you play in your project and company?

Visual studio 2012 Fakes

.NET interview questions: - So how can we clean unmanaged objects and also maintain performance?

ADO.NET Interview Questions: - What are basic methods of Data adapter?

.NET interview questions: - What are system level exceptions and application level exceptions?

.NET interview questions: - What is UML and which are the important diagrams?

.NET interview questions: - What is time out support in regex (regular expression)?

.NET interview questions: - How can we improve performance of .NET?

.NET interview questions: - Can you explain the concept of “Short Circuiting”?

.NET interview questions: - Can you explain Forms authentication in detail?

What is the difference between VAR and Dynamic keyword? ( .NET Interview questions with answers)

.NET interview questions: - What are similarities and difference between Class and structure?

Can you compare String.IsNullOrEmpty vs String.IsNullOrWhiteSpace ? ( .Net Interview questions with answers)

.NET interview questions: - Distinguish between Reflection and Dynamic?

.NET interview questions: - In which scenarios we can use serialization and when to use what binary serialization or XML serialization?

.NET interview questions: - Are there any readymade objects in .NET by which we can implement Lazy loading?

.NET interview questions: - What are different access modifiers?

ADO.NET interview questions: - Explain in detail the fundamental of connection pooling how to enable and disable connection pooling?

ADO.NET interview questions: - What is the namespace in which .NET has the data functionality class?

ADO.NET interview questions: - What are the different components in ADO.NET?

ADO.NET interview questions: - Show difference between “Optimistic” and “Pessimistic” locking and how many ways are there to implement optimistic locking in ADO.NET?

.NET interview questions: - Does code contract only do dynamic checks?

ADO.NET interview questions: - How can we fire a simple SQL Statement using ADO.NET?

.NET interview questions: - What basic steps are needed to display a simple report in crystal?

ADO.NET interview questions: - What are basic methods of Data adapter and mention the use of data adapter?

.NET interview questions: - What is UML? How many types of diagrams are there in UML?

.Net Interview Questions - What is MVC, MVP and MVVM pattern?

.NET interview questions: - How can you define a property read only for external world and writable in the same assembly?

Explain the implicit and explicit conversion of data types with examples?( .NET interview questions on data type)

.NET interview questions: - What is Reflection its implementation and practical uses?

What is downcasting and upcasting? (.NET interview questions with answers)

.NET interview questions: - How to decide on the design consideration to take a Data grid, data list or repeater?

.NET interview questions: - If we want to update interface with new methods, what is the best practice?

.NET interview questions: - How does selection sort algorithm works?

XML(.NET) interview questions: - What is XML?

.NET Interview questions: - If a validation is very complex what will you do?

.NET interview questions: - How can we stop the class from further inheriting?

XML (.NET) Interview questions :- Explain simple Walk through of XmlReader.

.NET interview questions : - How can we improve performance of .NET and show the difference between .NET 1.X, 2.0, 3.0, 3.5 and 4.0?

How to convert string to ENUM value ?( .NET interview questions with answers)

.NET architecture interview questions series: - What is mean by modeling language?

.NET architecture interview questions : - What are benefits and Limitation of using Viewstate, hidden frames and Cookies?

.NET interview questions: - What is GAC (Global Assembly Cache)?

.NET interview questions: - Explain Nuget?

.NET Testing interview questions: - What is the difference between Unit testing, Assembly testing and Regression testing?


.NET interview questions: - What is Code Access Security (CAS) and how does it work? Is CAS supported in .NET 4.0?


.NET interview questions: - What are the advantages /disadvantages of lazy loading?


.NET interview questions: - What is the use of DEBUG directive?


.NET testing interview questions: - What is Mock testing and how to implement it?


.NET interview questions: - What is the difference between DEBUG and Release?


.NET testing interview questions: - How can we UNIT test private methods using VSTS? Is it good to practice to UNIT test Private methods?


Explain 3 layer architecture ( .NET Interview questions)?


.NET interview questions : - What is a delegate and how can we create a delegate? What is a multicast delegate?


ADO.NET interview questions: - How to add/remove row is in “Data Table” object of “Dataset”? How to load multiple tables in a Dataset & adding relation between tables in a Dataset?


What is the difference between Array, ArrayList and List?( .Net Interview questions)

.NET interview questions: - How to implement DTC in .NET?



ASP.NET Interview Questions & Answers Article







ASP.NET interview questions: - Explain Application object and Cache object? 

What are application pools in IIS?( ASP.NET Interview questions)

ASP.NET interview questions: - How ‘Server.Transfer’ differs from ‘response.Redirect’ and when to use “Server.Transfer” or “Response.Redirect”? 

ASP.NET MVC interview questions series: - Explain HTML encoding in RAZOR and ASPX engine?

ASP.NET interview questions: - What is SQL Cache Dependency in ASP.NET? How do we enable SQL Cache Dependency in ASP.NET?

ASP.NET MVC interview questions: - Can you explain the life cycle of MVC?

ASP.NET MVC interview questions: - Explain Exception Handling in MVC?

What is CSS?( CSS Interview questions with answers)

ASP.NET MVC interview questions: - What are the differences between different versions of ASP.NET MVC - MVC2, MVC3 & MVC4?

Explain difference between server and client languages? ( ASP.NET interview questions)


Explain various session techniques? (ASP.NET Interview questions)


Explain functions of a web server? (ASP.NET Interview questions)


Explain page life cycle of ASP? (ASP.NET Interview questions with answers)



ASP.NET interview questions: - Differences and who performs faster between Grid view, Data list, and repeater? How to use a checkbox in a data grid?

ASP.NET interview questions: - What are the various modes of storing ASP.NET session? How can we do caching in ASP.NET?


ASP.NET interview questions: - How many types of validation controls are provided by ASP.NET?  How can we create custom controls in ASP.NET?


ASP.NET MVC interview questions: - What is WebGrid in MVC and how to use it?


ASP.NET caching interview questions: - What are different types of caching using cache object of ASP.NET? How can you cache different version of same page using ASP.NET cache object?


ASP.NET caching interview questions: - What are dependencies in cache and types of dependencies? What is Cache Callback in Cache?




WPF INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

6 important WPF and Silverlight Multi-threading interview questions with answers

C# WPF interview questions::- What are dependency properties ?

WPF Interview questions with answers: – What are WPF converters?

WPF interview questions on Events (Tunneling, bubbling and direct)

What are the advantages of using WPF ( WPF interview questions with answers)?

When should we use “x:name” vs “name” ? (C# WPF interview questions)

Explain WPF bindings?( .Net WPF Binding interview questions)

WPF Interview questions with answers :-What is XAML in WPF and why do we need it?

Explain the difference between visual and logical tree in WPF ? ( WPF Interview questions with answers)

What are the different kinds of controls in WPF?(C# WPF Interview questions with answers)

Can you explain the complete WPF object hierarchy?(WPF Interview questions with answers)

How does “UpdateSourceTrigger” affect bindings?( C# WPF interview questions with answers)

WPF Interview Questions:- Can you explain the overall architecture of WPF?

What are resources in WPF? (C# WPF Interview questions with answers)

Explain multi binding and multivalue converters? (.NET WPF  Interview questions with answers)

ASP.NET interview questions: - What are partial classes in ASP.NET?

Explain routed events in WPF (C# WPF interview questions with answers)?

Explain the difference between static and dynamicresource? (.NET WPF interview questions)

18 important WPF interview questions asked in WPF interviews.

Explain WPF relative binding / relative resource? (.NET WPF Interview questions with answers)

Explain Ancestor relative source binding in WPF ? ( WPF Interview questions with answers) 

Explain the need of binding and commands?(WPF Interview questions) 

Explain the need of “INotifyPropertyChanged” interface? ( C# WPF Interview questions with answers)

 

What is MVVM? (WPF MVVM Interview questions)

What are the benefits of MVVM?(WPF MVVM Interview questions)

What is the importance of command and bindings in MVVM pattern? ( WPF MVVM Interview questions)


What is the difference between MVVM and 3 layer architecture? ( WPF  MVVM Interview questions with answers)

 

WPF Interview questions with answers

 

Explain WPF styles?(C# WPF Interview questions with answers)

 

Explain Multitrigger concept in WPF?( C# WPF Interview questions with answers)

 

How are WPF observable collections different from simple .NET collections? (.NET WPF Interview questions)

 

What is the difference between control templates and data templates? ( .NET WPF Interview questions)

 

What are various ways of doing alignment in WPF?( WPF Interview questions with answers)

 

 

 

WCF INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

WCF interview questions and answers: - What is the difference between Service endpoint and Client endpoint

WCF interview questions with answers: - WCF REST vs. Web API

WCF interview questions with answers :- Can we have method overloading while defining WCF Service operations ?

WCF interview questions with answers :- What is DataContractSerializer and how it’s different from XmlSerializer ?

What is SOA and what is WCF? ( WCF interview questions with answers)

Six important WCF interview questions with answers 

6 important WCF Instancing interview questions with answers

WCF Service metadata interview questions with answers

7 WCF SOA interview questions with answers

What are the various ways of consuming WCF services?(WCF C# interview questions with answers)

What is the difference between Serialization and Encoding in WCF?( WCF interview questions with answers)

Why returning dataset or data table from WCF service is not a good practice?(WCF service interview questions with answers)

WCF transaction interview questions: - How transaction works in WCF?

WCF Transaction interview questions.

.NET WCF(Windows Communication Foundation) interview questions: - Distinguish between Web Services and Remoting | WCF and Web services




ENTITY FRAMEWORK INTERVIEW QUESTIONS ARTICLE


 

 

 

JQUERY INTERVIEW QUESTIONS AND ANSWERS ARTICLE

 
Jquery interview questions with answers: - What the difference between Javascript vs jQuery

ASP.NET JQuery interview questions with answers on Noconflict

3 Jquery interview questions with answers on onload,bind,live and hold ready

Jquery and javascript interview questions with answers :- How can do we create a simple Array and loop through it?

What is Jquery ? ( ASP.NET Jquery interview questions with answers)

Jquery.js VS Jquery.min.js file ( ASP.NET JQuery interview questions with answers)?

How does the basic syntax of Jquery looks like?( ASP.NET Jquery interview questions with answers)

What are the different ways by which you can select a HTML element in JQuery ? ( ASP.Net jquery interview questions with answers)

What is the use of Document.ready in Jquery ? ( ASP.NET Jquery interview questions with answers)

How can you make a JSON call using Jquery ? ( ASP.Net Jquery interview questions with answers)

How can we post JSON to Server? ( ASP.NET Jquery interview questions)

 

 

 

JAVASCRIPT INTERVIEW QUESTIONS WITH ANSWERS ARTICLE

 

3 important Javascript Important interview question with answers

How to debug javascript using visual studio? (ASP.NET Javascript interview questions with answers)

Explain unobtrusive JavaScript? ( MVC Javascript interview questions)

 

 

 

HTML 5 Interview questions With Answers Article

 

HTML 5 interview questions with answers for LocalStorage and SessionStorage

How is the page structure of HTML 5 different from HTML 4?( HTML 5 Interview questions with answers)

What is output element in HTML 5?( ASP.NET HTML 5 interview questions)

What is the difference between Canvas and SVG graphics?(ASP.NET HTML 5 interview questions with answers)

ASP.NET HTML 5 interview questions on SVG and Canvas

ASP.NET HTML5 interview questions with answers

What are web workers and why do we need them ?( ASP.NET HTML interview questions with answers)

Why do we need HTML 5 server-sent events? (ASP.NET HTML interview questions)

How can we add and remove data from local storage?(ASP.NET HTML 5 interview questions)

What is local storage concept in HTML 5? ( ASP.NET HTML 5 interview questions)

What is the difference between local storage and cookies? ( ASP.NET HTML 5 interview questions)

What is WebSQL?( ASP.Net HTML 5 interview questions)

What is session storage and how can you create one?( ASP.Net HTML 5 interview questions with answers)

What is application cache in HTML5?( ASP.NET HTML 5 interview questions with answers)

ASP.NET HTML 5 Application cache interview questions with answers 

Explain the term cascading in style sheet ? ( CSS Interview questions)

What is difference between DIV vs SPAN in HTML ?( ASP.Net Interview questions)


 


 

 

HR Interview Questions Article

 

HR interview questions: - Tell me something about yourself ?

 




Design Pattern Interview Questions With Answers Article

 

What is IOC and Dependency injection and how do they differ from each other?(Design pattern interview questions with answers)

Design pattern interview questions with answers

Factory Method Pattern vs. Abstract Factory Pattern

.NET Design Pattern interview questions: - What is Bridge Pattern?

 

 


Dotnetspider Questions And Answers Article

 

What is downcasting and upcasting ? ( .NET interview questions with videos)

What is the difference between String vs string? ( C# interview questions) ?

 

 

Learn MVC (Model view controller) Step by Step in 7 days

Learn MVC (Model View Controller) step by step in 7 days – Day 1

Learn MVC (Model view controller) Step by Step in 7 days – Day 2

Learn MVC (Model View Controller) Step by Step in 7 Days – Day 3

Learn MVC (Model view controller) Step by Step in 7 days – Day 4

Learn MVC (Model #mce_temp_url#view controller) Step by Step in 7 days – Day 5 

 

 

Windows Workflow Foundation(WWF) interview questions with answers Article

 

Windows Workflow Foundation(WWF) interview questions: - What is WWF? Explain Workflow? What are different types of Workflow in Windows Workflow Foundation?


WWF(Windows Workflow Foundation) interview questions: - What is the use of XOML files?

 

 

 

 

 

ADO.NET Interview Questions And Answers Article

 

Can you explain ADO.Net steps to connect to SQL Server database?( ADO.NET interview questions)

ADO.NET Entity framework Interview question PDF released

ADO.NET interview questions: - What is the use of data adapter? What are basic methods of Data adapter?

 

 

 

 

XML Interview Questions With Answers Article

 

 

 

Explain XML,DTD and XSL?(XML interview questions with answers)

 

 

 

 

JAVA/J2EE INTERVIEW QUESTIONS AND ANSWERS ARTICLE

 


 21 IMPORTANT JAVA/J2EE INTERVIEW QUESTIONS

21 IMPORTANT JAVA/J2EE INTERVIEW QUESTIONS

21 IMPORTANT JAVA/J2EE INTERVIEW QUESTIONS

21 IMPORTANT JAVA/J2EE INTERVIEW QUESTIONS

21 IMPORTANT JAVA/J2EE INTERVIEW QUESTIONS

21 IMPORTANT JAVA/J2EE INTERVIEW QUESTIONS

CORE JAVA & J2EE INTERVIEW QUESTIONS AND ANSWERS: – WHAT IS A STRING LITERAL IN JAVA?

CORE JAVA / J2EE INTERVIEW QUESTIONS WITH ANSWERS: – WHAT IS A FINAL CLASS IN JAVA?

JAVA INTERVIEW QUESTIONS AND ANSWERS: – WE HAVE RETURN IN THE TRY BLOCK, WILL FINALLY BLOCK EXECUTE?

JAVA INTERVIEW QUESTIONS: – 14 IMPORTANT QUESTIONS ASKED ON STRING HANDLING.

JAVA INTERVIEW QUESTIONS: – 14 IMPORTANT QUESTIONS ASKED ON STRING HANDLING.

JAVA INTERVIEW QUESTIONS: – 14 IMPORTANT QUESTIONS ASKED ON STRING HANDLING.

JAVA INTERVIEW QUESTIONS: – 14 IMPORTANT QUESTIONS ASKED ON STRING HANDLING?

JAVA INTERVIEW QUESTIONS: – 16 MOST ASKED IMPORTANT QUESTIONS ON I/O..

JAVA INTERVIEW QUESTIONS: – 16 MOST ASKED IMPORTANT QUESTIONS ON INPUT AND OUTPUT (I/O).

JAVA INTERVIEW QUESTIONS: – 16 MOST ASKED IMPORTANT QUESTIONS ON INPUT AND OUTPUT (I/O).

JAVA INTERVIEW QUESTIONS: – 16 MOST ASKED IMPORTANT QUESTIONS ON INPUT AND OUTPUT (I/O).

JAVA INTERVIEW QUESTIONS: – 20 BASICS INTERVIEW QUESTIONS ON JAVA? PART: -2.

JAVA INTERVIEW QUESTIONS: – 20 BASICS INTERVIEW QUESTIONS ON JAVA? PART: -2.

JAVA INTERVIEW QUESTIONS: – 20 BASICS INTERVIEW QUESTIONS ON JAVA? PART: -2.

JAVA INTERVIEW QUESTIONS: – 20 BASICS INTERVIEW QUESTIONS ON JAVA? PART: -2.

JAVA INTERVIEW QUESTIONS: – 25 BASICS INTERVIEW QUESTIONS ON JAVA?

JAVA INTERVIEW QUESTIONS: – 25 BASICS INTERVIEW QUESTIONS ON JAVA?

JAVA INTERVIEW QUESTIONS: – 25 BASICS INTERVIEW QUESTIONS ON JAVA?

JAVA INTERVIEW QUESTIONS: – 25 BASICS INTERVIEW QUESTIONS ON JAVA?

JAVA INTERVIEW QUESTIONS: – CAN YOU EXPLAIN BLOCKING QUEUES IN JAVA?

JAVA INTERVIEW QUESTIONS: – CAN YOU EXPLAIN COOKIES IN JAVA?

JAVA INTERVIEW QUESTIONS: – CAN YOU EXPLAIN NATIVE INTERFACE IN JAVA?

JAVA INTERVIEW QUESTIONS: – CAN YOU EXPLAIN NAVIGATION RULES AND HOW TO DECLARE THE SAME?

JAVA INTERVIEW QUESTIONS: – CAN YOU EXPLAIN THE FLOW BETWEEN BOOTSTRAP, EXTENSION AND SYSTEM CLASS LOADER?

JAVA INTERVIEW QUESTIONS: – CAN YOU EXPLAIN THE FUNDAMENTALS OF DEEP AND SHALLOW CLONING?

JAVA INTERVIEW QUESTIONS: – CONFIGURE TAG LIBRARIES IN STRUTS 1.XX VERSION?

JAVA INTERVIEW QUESTIONS: – CONFIGURE TAG LIBRARIES IN STRUTS 1.XX VERSION?

JAVA INTERVIEW QUESTIONS: – DESCRIBE JDBC AND STEPS INVOLVED IN THE JDBC CONNECTION.

JAVA INTERVIEW QUESTIONS: – DIFFERENT CORE INTERFACES OF HIBERNATE FRAMEWORK?

JAVA INTERVIEW QUESTIONS: – DIFFERENT FUNCTIONS PRESENT IN QUEUE INTERFACE.

JAVA INTERVIEW QUESTIONS: – DIFFERENT TYPES OF ROWSET IN JAVA 5?

JAVA INTERVIEW QUESTIONS: – ELABORATE BLOCKING QUEUES IN JAVA?

JAVA INTERVIEW QUESTIONS: – ELABORATE BLOCKING QUEUES?

JAVA INTERVIEW QUESTIONS: – ELABORATE COOKIES?

JAVA INTERVIEW QUESTIONS: – ELABORATE DIFFERENCE EAR, JAR AND WAR FILE?

JAVA INTERVIEW QUESTIONS: – ELABORATE DIFFERENT TYPES OF INNER CLASSES?

JAVA INTERVIEW QUESTIONS: – ELABORATE DIFFERENT TYPES OF INNER CLASSES?

JAVA INTERVIEW QUESTIONS: – ELABORATE DIFFERENT TYPES OF ROWSET IN JAVA 5?

JAVA INTERVIEW QUESTIONS: – ELABORATE NAVIGATION RULES?

JAVA INTERVIEW QUESTIONS: – ELABORATE THE FLOW BETWEEN BOOTSTRAP, EXTENSION AND SYSTEM CLASS LOADER?

JAVA INTERVIEW QUESTIONS: – ELABORATE THE LIFE-CYCLE PHASES OF JSF (JAVA SERVER FACES)?

JAVA INTERVIEW QUESTIONS: – ELABORATE WHY IS HTTP PROTOCOL CALLED AS A STATELESS PROTOCOL?

JAVA INTERVIEW QUESTIONS: – ENUMERATION, ARRAYLIST, HASHTABLE, COLLECTIONS AND COLLECTION.

JAVA INTERVIEW QUESTIONS: – EXPLAIN BLOCKING QUEUES IN JAVA?

JAVA INTERVIEW QUESTIONS: – EXPLAIN BLOCKING QUEUES?

JAVA INTERVIEW QUESTIONS: – EXPLAIN DIFFERENT TYPES OF INNER CLASSES?

JAVA INTERVIEW QUESTIONS: – EXPLAIN EAR, JAR AND WAR FILE?

JAVA INTERVIEW QUESTIONS: – EXPLAIN FUNCTIONS PRESENT IN QUEUE INTERFACE.

JAVA INTERVIEW QUESTIONS: – EXPLAIN HOW TO DO FLOW BETWEEN BOOTSTRAP, EXTENSION AND SYSTEM CLASS LOADED

JAVA INTERVIEW QUESTIONS: – EXPLAIN JDBC AND STEPS INCLUDED IN THE JDBC CONNECTION.

JAVA INTERVIEW QUESTIONS: – EXPLAIN NATIVE INTERFACE IN JAVA?

JAVA INTERVIEW QUESTIONS: – EXPLAIN PASSIVATION AND ACTIVATION IN EJB?

JAVA INTERVIEW QUESTIONS: – EXPLAIN THE FUNDAMENTALS OF DEEP AND SHALLOW CLONING?

JAVA INTERVIEW QUESTIONS: – EXPLAIN THE PREDEFINED RESULT TYPES.

JAVA INTERVIEW QUESTIONS: – FLOW BETWEEN BOOTSTRAP, EXTENSION AND SYSTEM CLASS LOADER?

JAVA INTERVIEW QUESTIONS: – HOW TO CONFIGURE TAG LIBRARIES IN STRUTS 1.XX VERSION?

JAVA INTERVIEW QUESTIONS: – HOW TO CONFIGURE TAG LIBRARIES IN STRUTS 1.XX VERSION?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU DISTINGUISH BETWEEN SERVLET AND RESTFULL WEB SERVICE?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU EXPLAIN COOKIES IN JAVA?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU EXPLAIN COOKIES IN JAVA?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU EXPLAIN DIFFERENT TYPES OF ROWSET IN JAVA 5?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU EXPLAIN EAR, JAR AND WAR FILE?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU EXPLAIN NAVIGATION RULES AND HOW TO DECLARE THE SAME?

JAVA INTERVIEW QUESTIONS: – HOW WILL YOU SHOW BLOCKING QUEUES?

JAVA INTERVIEW QUESTIONS: – IN HIBERNATE FRAMEWORK EXPLAIN THE CORE INTERFACES OF IT?

JAVA INTERVIEW QUESTIONS: – MENTION BLOCKING QUEUES?

JAVA INTERVIEW QUESTIONS: – MENTION DIFFERENCES BETWEEN ENUMERATION, ARRAYLIST, HASHTABLE, COLLECTIONS AND COLLECTION.

JAVA INTERVIEW QUESTIONS: – MENTION PASSIVATION AND ACTIVATION IN EJB?

JAVA INTERVIEW QUESTIONS: – MENTION THE FUNDAMENTALS OF DEEP AND SHALLOW CLONING?

JAVA INTERVIEW QUESTIONS: – MENTION THE LIFE-CYCLE PHASES OF JSF (JAVA SERVER FACES)?

JAVA INTERVIEW QUESTIONS: – MENTION THE PREDEFINED RESULT STRUTS.

JAVA INTERVIEW QUESTIONS: – MENTION US THE AVAILABLE CORE INTERFACES OF HIBERNATE FRAMEWORK?

JAVA INTERVIEW QUESTIONS: – PREDEFINED RESULT IN STRUTS?

JAVA INTERVIEW QUESTIONS: – SHOW BRIEFLY THE LIFE-CYCLE PHASES OF JSF (JAVA SERVER FACES)?

JAVA INTERVIEW QUESTIONS: – SHOW DIFFERENT TYPES OF ROWSET IN JAVA 5?

JAVA INTERVIEW QUESTIONS: – SHOW NATIVE INTERFACE IN JAVA?

JAVA INTERVIEW QUESTIONS: – SHOW PASSIVATION AND ACTIVATION IN EJB?

JAVA INTERVIEW QUESTIONS: – STATE DIFFERENCE BETWEEN SERVLET AND RESTFULL WEB SERVICE?

JAVA INTERVIEW QUESTIONS: – VARIOUS CORE INTERFACES OF HIBERNATE FRAMEWORK?

JAVA INTERVIEW QUESTIONS: – VARIOUS FUNCTIONS PRESENT IN QUEUE INTERFACE.

JAVA INTERVIEW QUESTIONS: – WHAT ARE BLOCKING QUEUES IN JAVA?

JAVA INTERVIEW QUESTIONS: – WHAT ARE COOKIES?

JAVA INTERVIEW QUESTIONS: – WHAT ARE DIFFERENT TYPES OF INNER CLASSES?

JAVA INTERVIEW QUESTIONS: – WHAT ARE NAVIGATION RULES AND HOW TO DECLARE THE SAME?

JAVA INTERVIEW QUESTIONS: – WHAT ARE THE DIFFERENCE BETWEEN SERVLET AND RESTFULL WEB SERVICE?

JAVA INTERVIEW QUESTIONS: – WHAT ARE THE FUNCTIONS PRESENT IN QUEUE INTERFACE?

JAVA INTERVIEW QUESTIONS: – WHAT ARE THE PREDEFINED RESULT IN STRUTS?

JAVA INTERVIEW QUESTIONS: – WHAT DO YOU MEAN ABOUT DIFFERENT TYPES OF INNER CLASSES?

JAVA INTERVIEW QUESTIONS: – WHAT DO YOU MEAN BY FUNDAMENTALS OF DEEP AND SHALLOW CLONING?


 

 

 

Create your blog for free on over-blog.com - Contact - Terms of Service - Earn Royalties - Report abuse - Most commented articles