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?

RAC

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

ASM

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?

RMAN

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?

Patching

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?

29 comments:

  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.
    Regards,
    Oracle Training in Chennai|Oracle DBA Training in Chennai|Oracle Training

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete

  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

    ReplyDelete