These below oracle DBA questions has been shared by a candidates who appeared for a interview in MNC. Candidate has 10 years of experience .

ROUND 1: ( Technical Round)

  • Background processes in oracle database
  •  Explain about dbwr and lgwr
  •  What is shared poool. What it does
  •  What is the role of PGA
  •  What it contains?
  •  What is the persistent area in PGA
  •  Explain how update statement works.
  •  Lets say, one user is updating and other one is selecting, How it will get the data.
  •  What is touchcount and its related question?
  •  What redo buffer contains.
  •  How recovery happens?
  •  What type of issues you face in oracle database
  •  How can we control db writer process.  What should the be the value of db writer process.
  •  Different status of buffer in buffer cache.
  •  Different status of redo logfile
  •  Can i drop a online redolog from oracle?
  •  What core dba issues you face
  •  How transaction recovery happens
  •  How update statement work flow happens
  •  RAC STARTUP SEQUENCE.
  •  DIFFERENT BACKGROUND PROCESSES in RAC.
  •  Role of ocr, vd.
  •  How many. Number of voting disk for 8 node RAC?
  •  Which file while starting cluster and what happens next?
  •  Why OLR  is required?
  •  What is gpnp profile
  •  Role of LMS, LMON, LMD, LCK,
  •  What is dynamic remastering
  •  What happens during instance reconfiguration
  •  Which process responsible for instance reconfig
  •  What is GCS,GES and GRD and which processes are responsible for this.
  •  What is past image
  •  Instance recovery in RAC
  •  Which proess does node eviction, Which node gets evicted
  •  Different protection modes in dataguard
  •  Which process gets the data from primary to standby
  •  Can we convert protection mode
  •  AFFIRM and NOAFFIRM
  •  What type of issues come in standby dataguard
  •  What are some parameters in dataguard
  •  What is fal_server
  •  What is log_archive_dest_1 and log_archiv_dest_2
  •  What is db_name and db_unique_name
  •  New features of oracle 19c dataguard
  •  What is far sync
  •  What is db_flashback_retention_target
  •  Different between dataguard and active dataguard
  •  Difference between force logging and supplemental logging
  •  Difference between classic and integrated
  •  What is the parallel integrated apply
  •  What is the coordinated integrated apply
  •  What is handle collision
  •  What is the common issues in goldengate and how you handle it
  •  What is discard file
  •  Where LCRs are stored
  •  Lets say process touched limit and you are unable to login with sysdba ,what you will do
  •  What is huge pages and why we need to enable hugepages.
  •  If database is running slow, what are the things we need to check.
  •  Why dbwr called lazy writer?
  • What is the voting disk timeout value?

ROUND 2:( Technical Round)

  • How select statement processing happens?
  • How insert statement processing happens?
  • Explain cache fusion
  • Explain cluster startup sequence
  • How asm gets started
  • Explain flex asm
  • How to enable flex asm
  • What is asm proxy?
  • How you can recover undo tablespace corruption.
  • While installing grid, what happens when you do root.sh script.
  • In flex asm , how database connects with asm
  • If you lost your OLR , How will you troubleshoot?
  • If you cluster node gets rebooted, which logs you will observer usually.
  • Explain how you apply patch manually in RAC
  • Lets say, you applied patch on node 2, and ran rootcrs.sh -post , and now the command is not coming out and error this patch mismatch, When you checked the oracle inventory , you found that patches are same . How you will troubleshoot it
  • Explain steps for node addition
  • Explain cache fusion , Which processes are responsing for cache fusion.
  • Explain write write scenarios in cache fusion
  • What is dynamic resource remastering? Is it good or bad?
  • If I remove the entry for spfile in gpnp profile, then will the crs start?
  • How you check the private interconnect issues.
  • How to do db upgrade.
  • What happens during db upgrade
  • How many phases are there in db upgrade
  • If I don’t do the timezone upgrade, will the database work.
  • What is far sync?
  • Which process send the redologs to standby
  • Which process received the data in standby
  • If block corruption happens in standby , how you willl recover it
  • What is multi instance redo apply . And how I can enable multi instance redo apply in dataguard.
  • What is sql quarantine .

ROUND 3( Managerial Round):

Mostly questions about

  • The candidate education history and work experience history.
  • Some high level question on database migration.
  • High level question on RAC node eviction.
  • Asked some question about some real time RAC issues that you faced in the past.
  • Asked about the certifications.
  • Asked whether any knowledge on oracle cloud or any other technologies
  • Asked whether any knowledge on exadata.
  • Asked how good you are at weblogic troubleshooting
  • Some discussion happened on salary and work related discussion

Current update

Candidate didn’t hear back from the Recruiter. Most probably candidate was not selected.