Re: Questions for a Jr. DBA
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: cicciuxdba@xxxxxxxxx
- Date: Mon, 7 Feb 2011 11:28:51 +0530
Alan,
it is really an interesting question..you are saying you want a team
member...unfortunately many do not understand dba is/has to be a team
member..many are of the opnion that just take a dip or force some one to
take a dip in a tank called as dba training, as soon as he/she came out of
the tank he/she will be more colorful dba !!!
technical questions/knowldege matters..which can be shaped/shrpened
further..provided a dba attitude exists..
so what is your need basically..present days are of outsourcing...hence some
of the times he/she may have to work remotely..so how much you can dependent
on him/her..without changing him/her..you have to get work done from
him/her..
recently I read the book 'How to be organised in spite of yourself'..penguin
books usa..authors sunny schlenger, roberta roesch..it gave me a different
way of looking..habbits, attitude, attribute, characterstics does matters..
thanks..subodh
On 7 February 2011 04:36, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx> 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.-
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
