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

please send me the model papers of statebankofindia(mains) as early as possible.exam is on nov 30th

1581


what is underwriting,warrrents and swapping

1746


What results did you achieve?

654


4. State & explain the various financial & non- financial incentives to motivate the people in an organisation.

1505


survivor management

2003






What are the main areas of activity you have had to keep track of?

648


(b) Define the terms: field, record, table and database.

1641


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

1626


Whether BOM is required even if SION is fixed for any particular product while preparing Advance Authorization?

1604


What are some ways in which a company can reduce the need of inventories?

1722


the following data has been furnished by s.ltd. regarding its salling machine : machine hours overhead costs(rs) 1350 3700 1520 4040 1670 4340 calculate the overhead costs at 1740 hours ?

1512


why DEPB Licence application is doing

1941


Does anyone ever face the problem about Oracle MRP that in MRP planner workbench not show where used for some make item that make it generates wrong demand and supply

1834


why should i give a job to you? what is your idol job? what are your strengths? how will be i was in next 5 years?

1521


i know the syllabus for the tax assistantexam but i would appreciate some tips fromyou on how to prepare for the general awareness paper.

1826