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.
- 2 Answers
- 24315 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Where would I get enough details about dell and wal-mart on how they compare to one another
How would you relate your key competencies to a Procurement Specialist position?
A. Distinguish between the individual and the group decision - making, explaining the advantages and disadvantages of group decision-making. B. Distinguish between individual change and organizational change.
what is stock exchange?
what change management process have you used to ensure that change is introduced properly
I have an experiance in retail industry, I want to expore more Retail industry, Pls suggest me to do Retail Management course.
How does information act in the controlling process?
what are your 4 biggest strengths and weaknesses to write into the admission form for MBA
Difference between BI and BW
How do you plan to achieve these goals?
A. What factor must be traded off by product development before introducing a new product? B. Explain the relationship between quality and productivity under the lean philosophy. B. Distinguish between pure and mixed strategies in production planning.
Dear Sir i am working in Infosys pune. I am thinking of doing MBA partime. Could you please list the universities in pune. Which have good Campus placement
Exaplain various risks associated with the new projects??
Why we calculate supplier PPM (Part Per Million).WE can calculate Supplier performance in % also, why PPM ?
why u have choosen finance has a specialisation
