Re: WANTED: Interview questions about Informix

In article 15367@cbnewsk.cb.att.com, chardin@cbnewsk.cb.att.com (christopher.hardin) writes: >Greetings, > > Every now and again, I have to interview programmers to fill a >contractor position. The problem I have is what do I ask these people? >They say they have N years experience with Informix; how can I prove it?. > > If you had to hire someone, what kind of questions would you ask? >I think the questions would have to range from ESQL/C to 4GL. Most of these >interviews are done over the phone, so the questions can't be too involved: >(Write a UNIX kernel using cat(1) Be brief but complete (grin)). 1. What's the advantage of using PUT over INSERT? Under what circumstances can you see the affect? What's the disadvantage? 2. What's a cursor? 3. In a given table, if you had a variety of sorting needs based on three different columns in various combinations (colA, colA+colB, colA+colB+colC, colB, colB+colC, colC), how many indexes would you create? Why? If the dude was in front of you -- 4. Write a short code segment (in a metalanguage if you'd like) that, given some typed in select statement by the user, executes the query and displays the result. There's a whole bunch of questions you could ask and I could list, but I tire easily. Ask loaded questions that will tell you a LOT from each response. --- -- Jerry