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?

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 */

---

start jogging on the spot, then invite the interviewee to join you. Take em through a workout - pressups & stuff, till they make excuses & leave.

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

Quote:

---

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.

Quote:

---

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.

You have this thing with strippin', dontcha?
But I won't say a word;)

Quote:

---

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!

:D

MH

Slimedave do you have a webcam ;) may be we can broadcast you over here :D

Quote:

---

Originally posted by adewri
Slimedave do you have a webcam ;) may be we can broadcast you over here :D

---

Amar,

Why exactly do you want to see slimdave naked?

Quote:

---

Originally posted by jovery
Amar,

Why exactly do you want to see slimdave naked?

---

D'Oh!

Quote:

---

Originally posted by jovery
Amar,

Why exactly do you want to see slimdave naked?

---

Oh was wondering if we could use him to advertise DBASupport.com to attract more visitors on the site ;)

May be we could arrange a Streaptease By Slimdave exclusively on DBASupport.com and Exclusively for Members, Join NOW ;)

Or may be we could scare away developers by saying that if they misbehave they will have to watch Slimdave Stripping Video VI ;) and show Slimdave's video :D, this would be the best way Hanky can torture his Developers.

So Slimdave, are you up for a bit of Amar's promotional work?

Do you think you've got what it takes to be the "face" of dbasupport.com :D

Well, it's suprising how an innocent comment about workplace-disrobing can get blown out of all proportion.

Now that's only twice this subject has been mentioned, and in both instances the removal of underwear was never an option!

Moving on ...

Actually I do have a webcam, but it's usually pointing at my fishtank so i don't have to turn my head to look at it. Much more soothing and viewable than the alternatives suggested. Less of freak show, anyway. Maybe I'll make an avatar of myself. That should be bad enough.

The key consideration of course is whether being the "face" of dbasupport would help me get a new contract -- preferably one that doesn't require that i fly to Ohio next week.

Quote:

---

Originally posted by jovery
Amar,

Why exactly do you want to see slimdave naked?

---

Jovery :

What did u geuess that Amar was upto from this first post...

suspect H***?? :D