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 is sql server query analyzer?

0 Answers  

Explain use of expression builder.

0 Answers  

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

What are the advantages of partitioning?

0 Answers  

Is the primary key column of a table an index in ms sql server?

0 Answers  

Can you explain what is the use of custom fields in report?

0 Answers  

what is difference between primary key and Unique

8 Answers  

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

Can sql servers link to other servers like oracle?

0 Answers  

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

Explain nested join?

0 Answers  

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories