Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Ques

Author  Topic 

aoriju
Posting Yak Master

156 Posts

Posted - 2011-04-21 : 04:52:48
Under which one of the following conditions do you consider the deployment of denormalization techniques?

Choice 1
A Decision Support System

Choice 2
A database with frequent but small transactions

Choice 3
A transaction system with frequent updates

Choice 4
An online stock trading system with very small and frequent updates

Choice 5
An Online Transaction Processing system

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-04-21 : 07:06:43
The expected answer is probably choice 1 but the correct answer is you would consider it for all of them and would need to know more about the system.


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-21 : 07:29:21
Sounds like an exam question, and a very poorly worded one at that.
Go to Top of Page
   

- Advertisement -