Oracle DBA Interview Questions

Real time interview question which was asked to one of our group member. 

Tell me about your self

What is your roles and responsibility in your organization?

Listed down topic wise questions:

Oracle Architecture

Explain Oracle architecture

What are the background processes?

What is the physical and logical structure in oracle?

Difference between SGA and PGA.

What is the use of temporary tablespace?

What if someone drop temporary tablespace?

Which process is responsible to write data to disk?


What is OCR and voting disk files?

How many disk should be configured for OCR and Voting disk?

RAC start-up sequence

What is cache fusion?

What is split-brain situation and how to overcome from it?

Explain 5 RAC processes

How to add node into RAC cluster?

Steps to implement oracle RAC on linux.

Some user is connected to one node and suddenly that nodes goes down because of some H/W issue so what will happen to the operation (select, insert) which has been executed by that user?

What is TAF and how we can configure it?

Convert non RAC db to RAC


What would be the status of ASM instance?

How to add disk into the ASM DG?

Minimum recommended ASM disk in ASM DG

Explain redundancy level in ASM

How to install ASM utility on Linux?

How to drop disk in ASM?


Which strategy are you using in your setup to take DB backup?

Difference between incomplete and complete recovery

Explain recovery scenario which you have faced in your environment

How to restore DB based on SCN?

How to catalog backup pieces?


Difference between CPU and PSU patching

How frequently are you applying patching

Step to apply CPU patch on RAC 

Step to apply patch in single instance

What are the prerequisites to apply patch

Upgrade and Migration

Have you participated in any upgradation activity?

How to upgrade 10g DB to 11gr2 and what all are the steps includes?

Which methods are available to upgrade DB?

What are the available technique to migrate the DB?

How to migrate DB from big endian to small endian?

Migration from non-ASM to ASM (RAC)

Performance Tuning

Have you worked on performance tuning activity?

If user complain that DB is running very slow than how start your investigation?

What is hugepages in linux and how it can be configured?

What is AMM?


  1. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    Oracle Training in Chennai|Oracle DBA Training in Chennai|Oracle Training

    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

  2. This comment has been removed by the author.

  3. Very nice post to keep sharing.. Thanks for giving very nice information from your post.. Selenium Training in Chennai | Selenium Training institutes in Chennai

  4. TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
    tv stand nz
    bike stand nz
    sofa bed nz


  5. It would have been the happiest moment for you,I mean if we have been waiting for something to happen and when it happens we forgot all hardwork and wait for getting that happened.
    AWS training in chennai | AWS training in anna nagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery

  6. This is a fabulous article, please try to give more useful information.
    python program for fibonacci series
    inheritance in python example

  7. This article will outline all the different strategies you should be aware of when it comes to soccer.

    Best IAS Coaching in India

  8. Escort Service In Gurgaon - Our call girls agency is ready to meet your all needs. They are enjoying most seductive female call Girls from different parts of the World. Have you ever date any female in your life? If no then you do not know the real taste of dating fun with a call girl. Then our Gurgaon Escorts service will help you to tackle your dreams with one of the independent female escort agencies.

    Escort Service In Gurgaon

  9. MPPSC Coaching in IndoreGet Free MPPSC Notes and MPPSC Study Material for preparation of MPPSC Exam.>