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...


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

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

How to update multiple rows with one update statement in ms sql server?

0 Answers  


How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  


WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  


what is create database syntax? : Sql server database administration

0 Answers  


Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  


What is normalization in Database ?

4 Answers  


What command do we use to rename a db, a table and a column?

0 Answers  


4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  


please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  


How to define output parameters in stored procedures?

0 Answers  


How many types of triggers are there?

0 Answers  


Why use cursor in sql server?

0 Answers  


Categories