Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 normalization vs de-normalization ? Rate Topic Display Mode Topic Options
Author
 Message
 Posted Wednesday, January 9, 2013 8:57 PM
 Forum Newbie Group: General Forum Members Last Login: Tuesday, January 15, 2013 10:16 PM Points: 4, Visits: 8
 In a recent test i was asked this questionwhen considering normalization vs de-normalization which of the following statements are correct?A)normalizations speeds up data retrieval at the expense of data modificationsB) de-normalization speeds up data modifications at the expense of data retrievalC)normalization is the process of putting one fact in numerous placesD)de normalization is the process of putting one fact in one placeE)none of the above
Post #1405149
 Posted Wednesday, January 9, 2013 9:07 PM
 Hall of Fame Group: General Forum Members Last Login: Saturday, October 24, 2015 2:31 AM Points: 3,158, Visits: 11,771
Post #1405152
 Posted Wednesday, January 9, 2013 9:11 PM
 Forum Newbie Group: General Forum Members Last Login: Tuesday, January 15, 2013 10:16 PM Points: 4, Visits: 8
 i went with answer B but not fully sure if it was the correct decision ....
Post #1405153
 Posted Wednesday, January 9, 2013 10:43 PM
 SSC-Insane Group: General Forum Members Last Login: 2 days ago @ 4:50 PM Points: 23,515, Visits: 37,731
 I may be wrong (meaning I misunderstood the answers), but I would go with E (None of the above).
Post #1405178
 Posted Thursday, January 10, 2013 5:21 AM
 SSCertifiable Group: General Forum Members Last Login: 2 days ago @ 3:25 AM Points: 7,933, Visits: 14,355
 Looks like A and B are polar opposites, as are C and D, so if only one choice could be correct then I would also go with E. __________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1405359
 Posted Thursday, January 10, 2013 5:52 AM
 SSC-Forever Group: General Forum Members Last Login: Yesterday @ 5:18 AM Points: 45,619, Visits: 44,147
 Where are these test questions from? Gail ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enterWe stand on the bridge and no one may pass
Post #1405365
 Posted Thursday, January 10, 2013 7:12 AM
 SSCoach Group: General Forum Members Last Login: Today @ 3:45 AM Points: 17,172, Visits: 32,133
 I'm not comfortable with any of those answers. A is somewhat true, but so is B. I'd have to choose E if pushed, but I'd want to have a long discussion about it. This test seems seriously messed up. What's it for? ----------------------------------------------------"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore RooseveltThe Scary DBAAuthor of: SQL Server Query Performance Tuning and SQL Server Execution PlansProduct Evangelist for Red Gate Software
Post #1405422
 Posted Thursday, January 10, 2013 7:19 AM
 SSC-Forever Group: General Forum Members Last Login: Today @ 10:10 AM Points: 42,046, Visits: 39,431
 I'm with Gail... this type of post seems to be becoming a habit with you. Where are these questions coming from? If they're coming from a MS test, I'd like to remind you that you agreed not to disclose the content of the test and you should stop posting them NOW. --Jeff Moden"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column." Helpful Links:How to post code problemsHow to post performance problems
Post #1405428
 Posted Thursday, January 10, 2013 8:03 AM
 SSC-Insane Group: General Forum Members Last Login: 2 days ago @ 4:50 PM Points: 23,515, Visits: 37,731
 If these questions are from a MS test, shoot the test writer. None of the answers really make sense.
Post #1405477
 Posted Thursday, January 10, 2013 8:35 AM
 SSCertifiable Group: General Forum Members Last Login: 2 days ago @ 3:25 AM Points: 7,933, Visits: 14,355
 Agreed, not about shooting the test writer but about the nonsensical options. You literally have to rule out all the real choices based on how ambiguous they are. "Compare and contrast normalization and de-normalization with respect to data modifications and the expense of data retrieval."Now that's a solid question, albeit that approach tends to fall down when writing a multiple choice exam __________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1405498

 Permissions