Basic Interview Questions
1. What is Oracle Database Architecture?
- Follow-up: Can you briefly explain the components involved?
2. What are the main components of the Oracle Database Architecture?
- Hint: Mention SGA, background processes, data files, control files, etc.
3. What is the System Global Area (SGA)?
- Follow-up: What are the different parts of SGA?
4. What are background processes in Oracle?
- Can you name a few important background processes?
5. What is the role of the Process Monitor (PMON) and System Monitor (SMON)?
6. What is a tablespace in Oracle?
- Follow-up: What is the difference between SYSTEM and SYSAUX tablespaces?
7. What is a control file and why is it important?
8. What are data files and how are they related to tablespaces?
9. What is the difference between a physical and a logical structure in Oracle?
10. What is the role of the redo log files in Oracle?
- Follow-up: What happens if the redo log is full?
🔹 Intermediate-Level Questions
11. Explain the difference between PGA and SGA.
12. What is an Oracle instance?
- Follow-up: How is it different from a database?
13. What happens during the Oracle database startup process?
- Stages: NOMOUNT, MOUNT, OPEN
14. What is the use of the control file during database startup?
15. What is the purpose of the listener in Oracle?
16. What is the difference between a dedicated and shared server architecture in Oracle?
17. What are data dictionary views?
- Example:
USER_TABLES,ALL_TABLES,DBA_TABLES