Below are the questions asked to a candidate in a production based company.
- In ansible, what type of activites you did?
- What is a role in ansible?
- How you can print the output in ansible task?
- How you handle errors in ansible?
- Explain the postgres architecture
- How connection gets established in postgres
- Different Components
- Where the data is stored in postgres
- What is vacuuming and vaccuming full and their difference.
- What MVCC? What is the advantage and disadvantage of this?
- What is visibility Map?
- What happens in the backend when we do vacuuming?
- Difference between awk and sed?
- What is the use of xarg?
- What is tee?
- How to list all the files inside a directory and sub-directories recursiverly .
- Which mongo db version you have worked
- What are some parameters in mongod.conf parameter
- What is bindip in mongod.conf
- Different protection modes.
- Different types of standby databases
- What is snapshot standby database and how it works
- If the standby setup in max protection mode and if the standby goes down, what will happen.
- How to fix if my archive is missing in standby
- Explain different migration process?
- How you can do cross platform migration?
- How you did migration using transportable tablespace?
- What is endian format?
- Different methods of cache fusion?
- Which processes are responsible for cache fusion?
- Where voting disk path is stored, ?
- How can I read GPNP profile?
- What is OLR, and which data is stored there?
- Why not voting disk path is not present in olr?
- In RAC, My one node is down, and getting error like vip already in use? What might be the issue?
- If a node , not coming up, how you troubleshoot it?
- What RAC scenarios you have faced in your environment?
- What proactive tasks you have done in your environment to improve the performance?
NOTE – You can share your interview experience with us, which will be helpful for our fellow DBAs.
