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 :-D
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato