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