Q2. What is the difference between a DATABASE and an INSTANCE in Oracle?

✅ Answer

• Database = Physical files (datafiles, redo logs, control files)
• Instance = Memory + Background processes (SGA + PMON + SMON etc.)

Production Scenario:

In RAC environments:

• One database is shared
• Multiple instances access it simultaneously