Interview questions
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Interview questions

  1. #1
    Join Date
    Oct 2001
    Posts
    24

    Thumbs up

    Hi all!
    One thing which is missing in this forum is regarding discussion about different type of Interview questions.I know that some guys will start like these things depends upon the company and the type of database they are using, but still it will be of great help for newbbies. For example
    Mr.MAVERICK recently attended one interview, he can post some of his quesions.

    bye
    eric

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Q - What do you think you can bring to the company?
    A - I can make it the base for my international porn syndicate!

    Q - Where do you see yourself in 5 years time?
    A - Doing your job when everyone sees I'm better than you!

    Q - What are your weaknesses?
    A - I get p*ssed off when people ask me stupid questions!

    Q - What are your strengths?
    A - I'm funny, intelligent, hansome, women love me and men want to be me!

    Q - What do you see as the role of IT in business?
    A - It's primary function is to make the workplace more fun by enabling you to pass jokes amongst your friends all day instead of working. Have you seen that Britney Spears screen saver?

    Q - How do you feel about working directly with customers?
    A - Depends how pretty they are!

    .....

    I've been asked all these questions over the years. Obviously, these weren't my real answers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Great :-)))))


  4. #4
    Join Date
    Dec 2001
    Posts
    139
    Brilliant Idea to look into to the memory structures (BRAIN) of working DBA's. It will definitely provide an insight about what all background processes are normally working in a DBA's head.


    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Originally posted by shaan
    Brilliant Idea to look into to the memory structures (BRAIN) of working DBA's. It will definitely provide an insight about what all background processes are normally working in a DBA's head.
    Probably less to do with how your typical DBA's brain works and more to do with how your typical mans brain works, when his wife's not listening
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  6. #6
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    My Experience

    Hi, 30th Jan 2002 16:49 hrs chennai

    Normally in interviews they ask this kind of Basic Questions.

    What is PCTFREE and PCTUSED

    What is ROWCHAINING and ROWMIGRATION

    What is TRANSACTION TABLE in RBS(Rollback segment)

    What are the ifferent Kinds of Tuning in Particular explain Application level Tuning-Differenr kinds-TKPROF etc.Also how do you collect statistics etc

    What is Buffer hit Ratio.Understand what is Physical read and Logical read(Consistent gets+DB Block gets)

    Simillarly all ratios limits for good performance for Shared Pool,RBS,Sorts,Log buffer etc.

    What are various Init.ora parameters

    Hot Back up or Online back up method or How it actually taken

    What will happen if during a export if discontinued due to power failure will the .dmp
    file contain information if so like what

    If you are taking a RMAN backup the Process fails abruptly like as said above what will be the status of the backup file

    PGA in dedicated and MTS difference

    Offcourse you should be very clear in Architecture -Memory Arcitecture and Process Architecture

    All the above Questions you should be very clear in depth not just explaining the definitions.

    Above all you should have 100% confidence how you project yourself cool and in control of the interview

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  7. #7
    Join Date
    Sep 2001
    Posts
    261
    Some general questions asked during my interview

    1. Narrate Your DBA experience.
    2. How to recover to point of falure or specific time
    3. Tuning Methodologies
    4. Daily DBA task that you perform
    5. What are the highlights of your DBA experience
    The Maverick
    Oracle Certified DBA - 8i

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    How to recover to point of falure or specific time
    Have you been really asked about that in an interview?? In Scandinavia, nobody goes into all that details at an interview. It is pointless. But that is why there is a 3 month trial period here, if you have said something you know how to do, and it happens you don't, then bye-bye :-))




  9. #9
    Join Date
    Jan 2001
    Posts
    3,131
    Tim; We should be working together, awesome!

    1) What is your name?
    2) What is you favorite color?
    3) What is the air speed velocity of an unladed swallow?


    Now the third question is a trick, make sure they specify African or European.

    MH
    I remember when this place was cool.

  10. #10
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Question 3 is easy:

    http://www.armory.com/swallow.html

    Alternatively look it up in:

    http://www.amazon.com/exec/obidos/ASIN/0865452814



    [Edited by TimHall on 01-30-2002 at 09:25 AM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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