I would consider a question about the Resource database valid in an interview (or QotD). In the interview environment, if asked "What are the system databases in SQL 2005?", if someone answered with the usual suspects, but missed "Resource", I would certainly hope that wasn't enough to fail the interview outright, but it would be something to consider.
On the other hand, last summer, in an interview, the company I was interviewing at placed a tremendous amount of importance on the fact that I don't have all the DBCC commands memorized. So, you never know what an interviewer is going to consider important vs trivial. (I thought it was odd that their DBAs couldn't read estimated execution plans, and didn't know about compile locks on procs. They thought it was deficient that I couldn't recite a list of DBCC commands. Different folks, different priorities. I hope whomever they did hire filled in some of their skill-gaps.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon