Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: some interview question

Re: some interview question

From: Murtuja Khokhar <>
Date: Fri, 15 Dec 2006 04:11:08 -0800 (PST)
Message-ID: <>

Thank you very much , Dennis and Alberto    

  I have compiled answer for my question.Please correct me or make it more meaningful    

  1. which type of things you will analyze about the database from your previous dba...when he is leaving and you are coming into the picture?
  2. Get the list of databases running
  3. Get the sys password of each database.
  4. Get the list of schemas available in each database.
  5. Must get the schema architechture and an overview of it.
  6. Backup plan and Schedule,Storage information,
  7. Try to know which type of disasters are happend with DB,It might happen again so is there any documents abt this?
  8. what you will do first when you join into the job regarding the database?
  9. Get the feed back from users regarding database performance.
  10. Enlist the weak performing areas either at report side or forms side.
  11. Get a general overview through v$system_events, v$sysstat view.
  12. More precisely generate a statspack report and study it throughly.
  13. What type of reports you can give to(Project Manager) about Database?
  14. Give a performance overview of the databases to ur proj. manager.
  15. Possible causes of performance issues like bad SQL, shortage of memory etc.
  16. Capacity Planning,Growth analysis,DB health report
  17. what type of documentation you will keep as a dba about project? You must keep the schema design documents, the data entry ratio on every object. Your recommendations, whether the object should be Cluster or IOT etc.
  18. if new project came to your can you planned and designed the database and what type of reports you will give to your project manager?

Alberto Dell'Era <> wrote:   I agree, looks like they want to put you in charge, giving you responsibility for some system(s). They seem to know their job.

On 12/15/06, Dennis Williams wrote:
> Murtuja,
> These sound like really insightful interview questions. You should
> definately consider working for this person. Answer these questions as
> straightforwardly and honestly as you can. your answers to these quesions
> will clearly demonstrate whether you have only mastered the technical
> aspects of being a DBA or the whole job.

Alberto Dell'Era
"Per aspera ad astra"

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
Received on Fri Dec 15 2006 - 06:11:08 CST

Original text of this message