what is difference between normalization and
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
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
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|
WHAT VISA YOU ARE APPLING FOR
Why do you want to study business management?
how to get BRC from Reserve Bank Of India , what is the procedure and waht type of forms submit in the bank and from where we get
Differance Between Stright Line and WDV Methed ?
difference between association and group?
Excise Duty Applicable for Assembly Materials E.g: I.T Products (Security Systems)
the question asked in 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 this answer in 5 to 6 pages in brief
Price leadership is a salient characteristic of: (a). Monopoly. (b). Perfect Competition. (c). Oligopoly. (d). Duopoly
How to make Private company into public limited company ?
Explain the purpose of an (infocube/cube) and dimensions. How do two components relate to each other? Why is it important to identify an organisation’s key performance indicators before developing a BI solution?
what do you mean by ERPS?
why you want to join private company?