Oracle/DBA 10g


Dear Expert,
Am Mohammed Sufyan from India and am Doing Course In Oracle, I would Like to know If i attend an interview as an DBA, what they expect from me, what type of question they will ask , am Doing 10g and am just finished my post graduate degree too am a fresher

Hi Mohammed,

As a 1st time junior DBA, you can expect many technical questions.

In Sureshgandhi's blog (, he identifies a number of good questions on

- Database structurs
- Memory Management
- Database Security
- SQL (including SQL*PLUS and PL/SQL)
- Constraints

That may include some topics on:
- basic DBA administration, patching, installation, configuration
- some knowledge about the Server OS environment where the DB and software is to be installed

Other sites with some technical questions include:

A more experience DBA ( be asked questions on these topics:
- Database Administration
- Backup / Recovery
- Performance tuning & optimization
- Auditing
- High Availability (using RAC, Dataguard, etc.)
- Data Streaming
- Data Modelling / Data Architecture

I hope this and the reference site helps.  


All Answers

Answers by Expert:

Ask Experts


Peter Choi


I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2016 All rights reserved.