I've already summarised my views about the DBIT exam experience, and Chris has ably summarised the questions, so what remains to be said?
"Answer all questions," read the rubric. This is fairly uncommon amongst the level-four exams (only DBIT4, AI4, DIP5 and NC4 require it), although it's become mandatory at level three, and it's quite clearly biting our colleagues in the arse. Whilst I can see the point of introducing it in some subjects (as Stu reminded me, it was possible to do AP3 without ever subclassing
java.lang.Thread, which can be problematic later; the solution does not appear to be found in dressing up multithreaded code in obscure "real-world" examples), it does seem to be contrary to the notion of specialising as you become more advanced. As a course, DBIT suffers in terms of coherence: large parts of the course are covered by taking DAS4 (CORBA, Servlets, JSP), Grid Computing (web services), Information Retrieval (search engines), NCT4 and SAC4; not to mention DB3, NSA3 and IM2. I know that, if many of those courses were answer-all-questions, I'd not have been as sanguine in those posts, and the term "modem-modem protocol" would be taboo.
Then again, consider the positives. Unlike the two previous database exams, it was well-timed, just fitting neatly into the extended, two-and-a-quarter hour allocation. The questions were all pretty fair (the CORBA question notwithstanding? It depends if you memorised that slide), and the questions on e-commerce were better-posed than in the sample paper. (There must be an art to devising a sample paper: neither can it be too similar to or too radically different from the actual exam, but who can be bothered summoning twice the imagination?)
As with most of these exams, it would have been possible (and indeed, conceivable) that the paper could have been contrived to be virtually impossible. Fortunately for us, Femi didn't.
PS. I've just noticed that The Bill is currently featuring a villain called Lewis Mackenzie. Perhaps our own Dr. Mackenzie e-mailed the writers to complain?