13 Replies Latest reply: Feb 20, 2013 7:46 AM by EdStevens RSS

    Interview Questions

    980503
      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
          Google it..
          • 2. Re: Interview Questions
            Chanchal Wankhade
            Hi,

            An interviewer can ask you
            Tell me about yourself.
            and Next would be :-
            Tell me about myseif.
            • 3. Re: Interview Questions
              980503
              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
                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
                  Yes i know
                  Oracle cert exam set up is crap.Just a way of making more money
                  • 6. Re: Interview Questions
                    APC
                    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
                      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
                        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_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
                            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
                              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
                                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
                                  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.