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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Good day Sir, Myself Anu Parakkal.I pursued my MBA in HRM,and i wish to take advance degree in Sea Port Management.Let me know the correct information about this.

1548


What is the difference between Bank rate and Repo rate?

1611


SAP SD. What are the Condition Conversion and Customer/Material conversion in the Organization Structure and should define and assign? Please nevigate and explain with example.

1592


Why should we hire you over the others waiting to be interviewed?

1598


Why was the unpopular decision necessary?

626






I have a BPO Experience and working as a Process and Soft Skils TrAINER , BUT THEY CAN ASK ME WHY AFTER TRAINING YOU SELECTED BUSINESS MANAGEMENT ,

1604


economics is considered as a part of MBA program while history and Gujarati is not why?

1602


As a business analyst, what tools you think are more helpful?

625


What happened in the end and what did you learn from the experience?

632


What techniques can you give to have a successful business?

1774


Tell me about a situation where your own team or department has had a problem working with an adjacent team

600


which goods comes under Form JJ & what is the meaning Form JJ If medical goods comes under this catagory?

1349


what is your team size

1829


3. Explain the factors that influence group effectiveness.

1662


advantages and disadvantages of the custer sampling

1741