Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is de-normalization and when do you do it?

Question Posted / latha sree

Answers were Sorted based on User's Feedback



What is de-normalization and when do you do it?..

Answer / swapna

As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.

Is This Answer Correct ?    7 Yes 3 No

What is de-normalization and when do you do it?..

Answer / praveen

Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.

Is This Answer Correct ?    1 Yes 0 No

What is de-normalization and when do you do it?..

Answer / praveen

If the database developer might want a reversal of
normalization to improve performance is called
denormalization.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the differences between having and where clause.

0 Answers  

Explain what are the database objects? : SQL Server Architecture

0 Answers  

CTE(common table expression)

1 Answers   Thomson Reuters,

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

What is a Join in SQL Server?

3 Answers  

What's the information that can be stored inside a bit column?

0 Answers  

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

What is data compression? : sql server database administration

0 Answers  

Why Master database is required?

0 Answers   Abacus,

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

For more SQL Server Interview Questions Click Here
Categories