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
- 24418 Views
- KPIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
why u have choosen finance has a specialisation
what is ROI stands for
what is reconceliation statement.
common question for merchandiser
how can i prepare for the interview for sap mm?
Why does a balance sheet show how much a business is worth? Why has there been an attempt to place value on human assets? On a balance sheet, why is capital shown next to liabilities?
sbi clerical exam question bank
19 Answers ABC, Bank Of India, CTS, LCC, Nihon Technology, Standard Bank, State Bank Of India SBI,
What are the main areas of activity you have had to keep track of?
0 Answers John Clark Motor Group,
financial management what will your out look towards maintenance of liquid assets to ensure that the firm has adequate cash in hand to meet its obligations at all times? i need answer in 5 to 6 pages please help me
How do you plan to achieve these goals?
New Entrepreneurs agengy was established on
0 Answers TNPSC Tamil Nadu Public Service Commission,
write brief notes and examples on the following terms 1. trade liberalisation 2. Structural Adjustment Program 3. Balanced development 4. NIEO
-
Business Administration (517) - Marketing Sales (1279)
- Banking Finance (3209)
- Human Resources (747)
- Personnel Management (68)
- Hotel Management (29)
- Industrial Management (113)
- Infrastructure Management (14)
- IT Management (97)
- Supply Chain Management (16)
- Operations Management (39)
- Funding (79)
- Insurance (494)
- Waste Management (1)
- Labor Management (48)
- Non Technical (73)
- Business Management AllOther (546)
