Yes it was me on...Based on Tom's "draw me an Oracle" concept, its a great way to "drill down" to bits and pieces of the database. Many an applicant can say "and here is the redo...needed for recovery" to which its easy to head down the road of: "so when you lose one of the datafiles you just drew, how does the redo help? What do I do to get that file back?" to see if they just "read" about redo, or actually know what's going on....etc etc Here's a funny story for you. Last set of interviews I ran, the HR person was also present. Before we started, the HR person was telling me about his questioning process and his questions were all (in my opinion) light-weight fluff.. "Tell me about challenges in the job" ... stuff like that. We had a light-hearted banter where I was telling him that any idiot could give the "right" answer to questions like that. Anyway, interviewee comes in, and the HR guy starts with his questions first. About his 5th question was: "Tell us about an obstacle you faced and how you overcame it" to which the applicant replies: "Someone phoned the help desk and needed to get access to a database that I was not responsible for, so I didn't have SYSDBA access. So I waited until after work, and when the cleaner went into the secure room where the passwords were kept, I slipped in behind him. When the cleaner left, I grabbed the passwords, hacked into the database, created the user account and gave them access!" HR guy and me just sat there silent, eyes wide, chins on floor for about 30 seconds. When the applicant finally left, HR guy gives me a smug smile and says: "I told you my questions would work!" :-) Cheers Connor --- Rachel Carmichael <wisernet100@xxxxxxxxx> wrote: > Question 2 -- intimidation. yep. that's definitely someone I want to > work for, someone who tries to bully me on an interview. Yep. > > I can top your 3.5 hour interview.... I interviewed at one company > where I was there from 9am until 4pm, saw 11 people. Even lunch was > part of the interview, I talked with HR. We ranged from detailed DBA > work to design to network/system administration to management theory. > > ===== Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@xxxxxxxxx Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------ ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------