Re: Questions for a Jr. DBA

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 6 Feb 2011 20:11:41 -0600
Message-ID: <AANLkTinaEj80ESB7QHfzbAUvn7-kEHiw8h7=a0U=MiBs_at_mail.gmail.com>

Depending on what you have him/her doing, you might ask:

 the basic steps to tuning a query.
What to do if you have a bunch of processes blocked. what to do in case of an ora-600/ora-7445 maybe some basic change control
what to do with an archiver hung error.

On Sun, Feb 6, 2011 at 5:06 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>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.-
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 06 2011 - 20:11:41 CST