80 Best Oracle DBA Interview Questions answers for experienced professionals Part1 [ 2023 ]

Oracle DBA Interview Questions/FAQs Part1

1. What is an instance?
Answer :

Memory/SGA + background processes.

2. What is SGA?
Answer :

System/Shared Global Area.

3. What is PGA (or) what is pga_aggregate_target?
Answer :

Programmable Global Area.

4. What are the new memory parameters in Oracle 10g?
Answer :

SGA_TARGET PGA_TARGET

5. What are the new memory parameters in Oracle 11g?
Answer :

MEMORY_TARGET

6. What are the mandatory background processes?
Answer :

DBWR LGWR SMON PMON CKPT RECO.

7. What are the optional background processes in the Oracle database?
Answer :

ARCH, MMAN, MMNL, MMON, CTWR, ASMB, RBAL, ARBx, etc.

8. What were the new background processes introduced in Oracle 10g?
Answer :

MMAN MMON MMNL CTWR ASMB RBAL ARBx

9. What were the new features in Oracle 9i?
Answer :

http://satya-dba.blogspot.com/2009/01/whats-new-in-9i.html

10. What were the new features in Oracle 10g?
Answer :

http://satya-dba.blogspot.com/2009/01/whats-new-in-10g.html

11. What were the new features in Oracle 11g?
Answer :

http://satya-dba.blogspot.com/2009/01/whats-new-in-11g.html

12. What were the new features in Oracle 11g R2 (release 2)?
Answer :

http://satya-dba.blogspot.com/2009/09/whats-new-in-11g-release-2.html

13. What were the new features in Oracle 12c (release 1)?
Answer :

http://satya-dba.blogspot.com/2012/10/new-features-in-oracle-database-12c.html

14. What process will get data from datafiles to DB cache (Database buffer cache)?
Answer :

Server process

15. Which background process will write data to datafiles?
Answer :

DBWR

16. Which background process will write undo data?
Answer :

DBWR

17. What are the physical components of the Oracle database?
Answer :

Oracle database is comprised of three types of files. One or more datafiles, two or more redo log files, and one or more control files. Password file and parameter file also come under physical components.

18. What are the logical components of Oracle database?
Answer :

Blocks, Extents, Segments, Tablespaces.

19. What is segment space management?
Answer :

LMTS and DMTS.

20. What are the differences between LMTS and DMTS?

Answer :
Tablespaces that record extent allocation in the dictionary are called dictionary managed tablespaces, and tablespaces that record extent allocation in the tablespace header are called locally managed tablespaces.

Related Oracle Interview Articles: Oracle DBA Interview Questions/FAQs – Part2   Oracle DBA Interview Questions/FAQs – Part3   Oracle DBA Interview Questions/FAQs – Part4