This discussion is archived
13 Replies Latest reply: Feb 20, 2013 5:46 AM by EdStevens RSS

Interview Questions

980503 Newbie
Currently Being Moderated
What questions you could expect for the post of developer having 2-2.5 years of experience.

I know this is generic question and will purely depend on the type of work required.But still i would like to know what you would be asking .
NO DBA questions
  • 1. Re: Interview Questions
    jeneesh Guru
    Currently Being Moderated
    Google it..
  • 2. Re: Interview Questions
    Chanchal Wankhade Journeyer
    Currently Being Moderated
    Hi,

    An interviewer can ask you
    Tell me about yourself.
    and Next would be :-
    Tell me about myseif.
  • 3. Re: Interview Questions
    980503 Newbie
    Currently Being Moderated
    what would you ask?
    select * from dual where 5 > ANY ( 4,3,2,-1)
     my expected o/p was 0 rows but i am getting 1 row as o/p .why?
    
    same with this 
    select * from dual where 5  > ALL ( 4,3,2,-1);
    Edited by: Oracle_Monkey on Feb 20, 2013 2:52 AM
  • 4. Re: Interview Questions
    APC Oracle ACE
    Currently Being Moderated
    ANY and ALL feature heavily in Oradle cert exams but they are pretty irrelevant to actual work. In fact, I would suspect anybody who knows about them to have more booklearning than practical experience.

    Cheers, APC
  • 5. Re: Interview Questions
    980503 Newbie
    Currently Being Moderated
    Yes i know
    Oracle cert exam set up is crap.Just a way of making more money
  • 6. Re: Interview Questions
    APC Oracle ACE
    Currently Being Moderated
    I don't ask questions which can be resolved by looking up the documentation i.e. pure syntax questions. But it is important to probe technical ability and knowledge. So I wouild ask (and indeed have asked) questions on:

    - data modelling
    - tuning SQL and PL/SQL
    - design methodologies for building PL/SQL
    - favourite tools
    - best practice e.g. exception handling

    The key thing is questions about past projects: I want to know what the individual candidate contributed. People who only describe the project, or speak in the plural - "we did" - are almost certainly covering up for a junior or limited participation on a project. Be careful with your CV (resume): anything you put on there is fair game so don't pad it out.

    The other thing is to try to get an actual technical test in there. I've come across people who can talk a good game but can't code for toffeee.

    Cheers, APC
  • 7. Re: Interview Questions
    BluShadow Guru Moderator
    Currently Being Moderated
    Oracle_Monkey wrote:
    what would you ask?
    select * from dual where 5 > ANY ( 4,3,2,-1)
    my expected o/p was 0 rows but i am getting 1 row as o/p .why?
    
    same with this 
    select * from dual where 5  > ALL ( 4,3,2,-1);
    But 5 is greater than ANY of the values in (4,3,2,-1)
    and 5 is also greater than ALL of the values in (4,3,2,-1)

    so of course it will return the row from dual as the condition is met in both cases.

    What logic made you think that it should return 0 rows?
  • 8. Re: Interview Questions
    980503 Newbie
    Currently Being Moderated
    Blu i cleared my concept of Any and ALL.
    Thanks
    Are they used in production code?


    apc
    - design methodologies for building PL/SQL
    What do you mean by this and what answer you expect?
  • 9. Re: Interview Questions
    APC Oracle ACE
    Currently Being Moderated
    Oracle_Monkey wrote:
    Are they used in production code?
    That is actually a good question to trow back an interviewer. Because it is okay to say "I don't know". If you have never come across ANY or ALL in production, say so and ask the interviewer for an example of where they've used them and why they used an obscure construct.

    Tim Hall has a good overview on [url http://www.oracle-base.com/articles/misc/all-any-some-comparison-conditions-in-sql.php]Oracle-Base.

    Cheers, APC

    Edited by: APC on Feb 21, 2013 9:07 AM
  • 10. Re: Interview Questions
    APC Oracle ACE
    Currently Being Moderated
    Chanchal Wankhade wrote:
    Hi,

    An interviewer can ask you
    Tell me about yourself.
    and Next would be :-
    Tell me about myseif.
    And the correct answer to the second question is "you're an irritating blowhard who likes to play mindgames in interviews. Do I get the job?"

    Cheers, APC
  • 11. Re: Interview Questions
    BluShadow Guru Moderator
    Currently Being Moderated
    Oracle_Monkey wrote:
    Blu i cleared my concept of Any and ALL.
    Thanks
    Are they used in production code?
    I've never ever used them in any of the code I've written, or (fortunately) seen it used by any code written by any other colleagues or experts elsewhere.
  • 12. Re: Interview Questions
    Marwim Expert
    Currently Being Moderated
    Tell me about yourself.
    and Next would be :-
    Tell me about myseif.
    In this interview I would fail for not knowing the word +myse i f+ :-)
  • 13. Re: Interview Questions
    EdStevens Guru
    Currently Being Moderated
    Oracle_Monkey wrote:
    Blu i cleared my concept of Any and ALL.
    Thanks
    Are they used in production code?


    apc
    - design methodologies for building PL/SQL
    What do you mean by this and what answer you expect?
    When I have conducted interviews I have been more interested in the candidate's thought process and approach to a problem than his ability to spout a canned answer. To that end, I ask open-ended questions for which the correct answer starts with "It depends ..".
    I always throw in a couple of questions for which there is no correct answer .. questions that assume a falsehood. I do that just to see how the candidate responds. I'm looking for a candidate that will question the questions.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points