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 inline table-value user-defined function?

0 Answers  

What is triggers and stored procedures?

0 Answers  

How can you control the amount of free space in your index pages?

0 Answers  

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

how do u find least salary in a table

4 Answers  

Explain following error properties?

0 Answers  

How to download and install the scaled-down database adventureworkslt?

0 Answers  

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

List out the differences between global and local temp tables in sql server?

0 Answers  

How do I save a stored procedure in sql server?

0 Answers  

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

0 Answers  

For more SQL Server Interview Questions Click Here
Categories