Overview:

Below are the questions asked to a candidate with 10 years of experience in Oracle DBA and postgres . There were 2 rounds.

 

Round 1 :

  •  What are your day to day activities. And what is your role in the Team?
  • Explain cluster startup sequence.
  • Suppose users are connected to node1 and Os team, want to do emergency maintenance and they need to reboot. What wil happens to the transactions on node1 , and can we move them to node 2.
  • What are the advantages of partitioning?
  • Can we convert non-partitioned table to partitioned table online( in production)?
  • What are the cloning methods. And what is the difference between duplicate method and restore method?
  • How can we open the standby database as read write for testing and Once testing is done need to revert to previous position. But without using snapshot command?
  • Explain how you did grid upgrade.
  • Which advanced security features you have used ?
  • What is audit purging?
  • Lets says a query was running fine for last few days , but today it is not performing well. How you will troubleshoot it?
  • What is oracle in memory ?
  • Explain what type of patches you applied on grid.
  • As per resume ,You have worked on ansible . So how good you are with ansible and what type of scripts you have wrote.
  • How can you troubleshoot a shell script?

2nd round:

  • Explain ASM architecture , means when ever user runs a query, how it gets the data from ASM.
  • Why ASM performance is better
  • Why VIP is used , Bcoz before 10g vip was not used. What benefits vip provide
  • What is Current block and CR block in RAC
  • What wait events are there in RAC??
  • What is gc buffer busy wait
  • What is gc 2 way current wait, gc 3 way current wait.
  • What is node eviction. In which cases it happens.
  • How you do load balancing using services in your project. Explain
  • What activities you did using goldengate
  • How you did upgrade/migration using goldengate.
  • What is goldengate instantiation.
  • What is bounded recovery in goldengate
  • What is the difference between CSN in goldengate vs SCN in database?
  • Which type of os tool/commands you have used for os monitoring/performance. And how you read it.
  • How you troubleshoot I/O issues in oracle
  • What type of sql performane tools you use.
  • How you migrate a plan from one db to another db
  • What is the dbms package for baseline and sql tuning?
  • Lets say, despite importing the baseline, query is not picking the plan, What can the be reason?
  • What is index fast full scan and index range scan?
  • What is the purpose of standby redolog.
  • Any automation tools you have used?
  • Did you worked on jenkins or gitlab?
  • What activities you did in postgres.
  • How you implement backup in postgres.
  • Is your postgres cluster active active or active passive?
  • Can we create a active active postgres cluster?
  • Do you remember any postgres extensions?
  • What type of scripts you have written on ansible?
  • Tell me some modules of ansible.
  • How can we encrypt the server credentials in ansible.

 

 

 

If you wish to share your interview experiences, then please drop a mail to support@dbaclass.com. We will happy to publish it with your permission.