Stupid and/or Obscure Technical Interview Questions
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Stupid and/or Obscure Technical Interview Questions

  1. #1
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Stupid and/or Obscure Technical Interview Questions

    I'm looking for questions that I can put to interviewees that will piss them off or make them feel stupid. The aim is that if i decide half way through a technical interview that they're not going to get the job, i need some of these to continue with.

    So far, I've got ...

    i) What language is PL/SQL syntax based on (answer ADA, as discussed in the forums a while ago. This I would classify as a stupid interview question.)

    ii) How do you populate a number column with a value of positive or negative infinity? (answer, you have to import it from an Oracle 5 database. This would be an obscure question)

    Well you see the pattern. There's a real answer, but who gives a crap about it?

    Anyone else got any?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Well you could ask them what the following hexa values stand for in the trace files

    Code:
    /* 0x01 = typed table, 0x02 = has ADT columns, */
    /* 0x04 = has nested-TABLE columns, 0x08 = has REF columns, */
    /* 0x10 = has array columns, 0x20 = partitioned table, */
    /* 0x40 = index-only table (IOT), 0x80 = IOT w/ row OVerflow, */
    /* 0x100 = IOT w/ row CLustering, 0x200 = IOT OVeRflow segment, */
    /* 0x400 = clustered table, 0x800 = has internal LOB columns, */
    /* 0x1000 = has primary key-based OID$ column, 0x2000 = nested table */
    /* 0x4000 = View is Read Only, 0x8000 = has FILE columns */
    /* 0x10000 = obj view's OID is system-gen, 0x20000 = used as AQ table */
    /* 0x40000 = has user-defined lob columns */
    /* 0x00080000 = table contains unused columns */
    /* 0x100000 = has an on-commit materialized view */
    /* 0x200000 = has system-generated column names */
    /* 0x00400000 = global temporary table */
    /* 0x00800000 = session-specific temporary table */
    /* 0x08000000 = table is a sub table */
    /* 0x20000000 = pdml itl invariant */
    /* 0x80000000 = table is external  */
    /* 0x00000001 = deferred RPC Queue */
    /* 0x00000002 = snapshot log */
    /* 0x00000004 = updatable snapshot log */
    /* 0x00000008 = context trigger */
    /* 0x00000010 = synchronous change table */
    /* 0x00200000 = table had rowmovement */
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Nov 2002
    Posts
    80
    start jogging on the spot, then invite the interviewee to join you. Take em through a workout - pressups & stuff, till they make excuses & leave.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Ask them if they mind working third shift? That'll weed out about 70% right there.
    Tell them they have to be on pager support indefinatly.

    I'll think of more later.

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by Mr.Hanky
    Ask them if they mind working third shift? That'll weed out about 70% right there.
    Tell them they have to be on pager support indefinatly.

    I'll think of more later.

    MH
    ... and no remote access, even for 3am callouts.

    But then if they don't mind working third shift, that just tells you they're either ...

    i) a loser with no friends or life outside work, or ...
    ii) desperate for any work at all

    ... so if they agree then you just kick their ass out anyway.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by onlysimon
    start jogging on the spot, then invite the interviewee to join you. Take em through a workout - pressups & stuff, till they make excuses & leave.
    .. or start slowly stripping down to your underwear, while keeping the interview going as if everything was normal.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    You have this thing with strippin', dontcha?
    But I won't say a word
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #8
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by Tarry
    You have this thing with strippin', dontcha?
    But I won't say a word
    That's why he works from home, he's naked at all times.

    FrEaK!



    MH
    I remember when this place was cool.

  9. #9
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Slimedave do you have a webcam may be we can broadcast you over here
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  10. #10
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by adewri
    Slimedave do you have a webcam may be we can broadcast you over here
    Amar,

    Why exactly do you want to see slimdave naked?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width