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 difference between normalization and
denormalization.
in normalization all tables are normalizad format or not.
what r the types of indexes are there.
what is difference b/w bitmap,b-tree,unique and function
based indexes.

Answers were Sorted based on User's Feedback



what is difference between normalization and denormalization. in normalization all tables are nor..

Answer / karthikeyan

Denormalization is the process of attempting to optimize the
performance of a database by adding redundant data or by
grouping data.
Normalization is the process of de-composing a relation with
anomalies into a well structured relation.

Is This Answer Correct ?    16 Yes 1 No

what is difference between normalization and denormalization. in normalization all tables are nor..

Answer / samarth

Denormalization is the process of introducing redundancy
into a table by incorporating data from a related table.
Tables are usually denormalized to prevent expensive SQL
join operations between them.

One should always normalize to third-normal form and only
apply denormalization selectively as a last resort if
performance problems are experienced. Remember that
denormalizations is not free and introduces the following
problem into the design:
More disk space is used as the same data is duplicated in
more than one table
DML operations are more expensive as the same data must be
maintained in more than one table
You run the risk that the data can get "out of sync"

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More Business Management AllOther Interview Questions

Differentiate between corporate planning and stratigic planning.

0 Answers  


Who do you involve in this process?

0 Answers   John Clark Motor Group,


What Do you Mean by Wall Management?

0 Answers   Ernst Young,


what is the function of financial manager?

1 Answers  


what are your 4 biggest strengths and weaknesses to write into the admission form for MBA

0 Answers   ASD Lab,


How would you compare Dell to Wal-mart

1 Answers  


What are the different label of management that are found a large organization?

0 Answers  


what do you mean by decision support system(DSS)?

2 Answers  


can i take the specialization for MBA HR and system is it good my career? will it work out?

0 Answers  


(b) Describe how to safeguard a system through acquisition of an antivirus Program and systematic backup.

0 Answers  


Being a researcher in marketing company, how can you search the opportunities and monitor the threats of your product?

0 Answers   DLF,


state the importance of fixed maximum fiduciary system

0 Answers  


Categories
  • Business Administration Interview Questions Business Administration (517)
  • Marketing Sales Interview Questions Marketing Sales (1279)
  • Banking Finance Interview Questions Banking Finance (3208)
  • Human Resources Interview Questions Human Resources (747)
  • Personnel Management Interview Questions Personnel Management (68)
  • Hotel Management Interview Questions Hotel Management (29)
  • Industrial Management Interview Questions Industrial Management (113)
  • Infrastructure Management Interview Questions Infrastructure Management (14)
  • IT Management Interview Questions IT Management (97)
  • Supply Chain Management Interview Questions Supply Chain Management (16)
  • Operations Management Interview Questions Operations Management (39)
  • Funding Interview Questions Funding (79)
  • Insurance Interview Questions Insurance (494)
  • Waste Management Interview Questions Waste Management (1)
  • Labor Management Interview Questions Labor Management (48)
  • Non Technical Interview Questions Non Technical (73)
  • Business Management AllOther Interview Questions Business Management AllOther (546)