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.
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 |
Business Managment
What is equity share suspense?
A. What kind of decisions is a manager generally required to make in the organizational context? Explain with examples as to which of these correspond to programmed and non-programmed categories B. Discuss various strategies used in implementing organisational change in the context of a large manufacturing company.
Management can be thought of as a process, a discipline , a human activity and a carrier ? Do you agree?
The Department’s budget is currently $35 million dollars. Please outline for us your experience with budgets and key points for successful operations.
5. Identify & explain the responsibilities of the sender & the responsibilities of the receiver in the communication process.
is there is rule that service tax credit raises at point of time when we make payment or we can take service tax credit on basis of invoice we received ? for example if i have got the bill in april month and i have paid in july month than when i can take service tax credit in april or in july .
(a) Describe the My Computer and My Documents folders; identify the elements that are present in every Window.
In Excell sheet how v-lookup can be used?
Briefly describe your ideal job?
why u have choosen finance has a specialisation
How did you track progress?
0 Answers John Clark Motor Group,
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)