Re: Informix Interview Questions

> Ian Goddard <igoddard@netcomuk.co.uk> writes: > Laura Eschner wrote: > >I'm looking for interview questions (and answers) that could be asked > >during an interview for a Informix DBA position to ensure that the > >person knows what they're doing. > > A good interview question is not necessarily one that elicits specific > answers but explores how the candidate approaches a problem. > Ian > >>>> You might also ask what kinds of factors are involved in tuning the engine. or how they went about tuning previous engines. I'm a new DBA so I can't provide really great answers, but I'm learning how important this subject is...and how complicated. Ask them how big the database(s) were that they administered before and how many users. Size can make a big difference in how you handle a particular database. They should at least be able to say, for example, "1 production/OLTP database with 7 G with 60+ users, 1 development database that duplicated production with 7 developers and 1 DSS database that was 15 G with 15 users" If they don't know those kinds of basics..... I would wonder... Also, a database in the terabyte-sized region would be much different than a little old 7 G database. For example, a 7 G database doesn't necessarily benefit much from fragmented tables. The maintenance overhead could cost more than it's worth. Good luck.