Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priya
Denormalization is the process of putting one fact in
numerous places (its vice-versa of normalization).Only one
valid reason exists for denormalizing a relational design -
to enhance performance.The sacrifice to performance is that
you increase redundancy in database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is sub-query? : Transact sql
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Explain the select statement in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
what is 'mysqldump'? : Sql dba
Can you have more than one key in a database?
What are the two types of exceptions in pl/sql?
What is bind variable in pl sql?
How do I view tables in sql developer?
Can we join two tables without common column?
Can a select statement fire a trigger?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Which data dictionary views have the information on the triggers that are available in the database?
What are the different operators available in sql?
how to convert numeric values to character strings? : Sql dba
