Re: Questions for a Jr. DBA
Date: Mon, 7 Feb 2011 14:00:06 +0100
Message-ID: <20110207130006.GA4295_at_app01.bos>
The thing I really find important is comunicative skills. I would rather hire someone with good communication skills then someone with technical knowledge.
It's my experience that technical skills are learned much easier then communication skills.
Ofcourse the candidate should have some basic technical DBA knowledge. But since we are talking junior DBA, I would not ask to many heavy technical questions.
Best Regards,
Martijn
On Sun, Feb 06, 2011 at 08:06:24PM -0300, Guillermo Alan Bort wrote:
> So, I am in the process of reviewing resumes from several JR and SSR
> candidates for the team. The question I came up with is, what kind of
> questions (technical) should I ask during the interview. I can't use the
> same questions I'd use with a Sr. DBA.
>
> The questions i've come up with so far are the following:
> 1. Difference between EXTENT and BLOCK
> 2. Difference between USER and ROLE. When would you use each?
> 3. Command to extend a Tablespace (tricky question? should it be datafile?)
> 4. Command to backup controlfiles (all you can think of)
> 5. Steps to switch archivelog on or off.
> 6. Minimum requirements in order to take a level 1 online backup (tricky
> question?)
> 7. What are the minimum required files to be backed up in order to be able
> to recreate the database from scratch in the event of complete media
> failure?
>
> I may come up with more, but that's what I have so far...
>
> thanks in advance
> Alan.-
>
>
-- Met vriendelijke groet, Martijn Bos (06 39477001) -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 07 2011 - 07:00:06 CST