Access Infotech Oracle Database Administrator Interview Questions, Process, and Tips

Oracle database architecture consists of memory structures, background processes, and physical files.

• Memory structures include SGA and PGA

• Background processes include PMON, SMON, DBWn, LGWR, CKPT, etc.

• Physical files include data files, control files, redo log files, etc.

• Oracle database architecture follows a client-server model

• Oracle database architecture supports multi-tier architecture

Background processes are processes that run in the background of an operating system without user interaction.

• They perform tasks such as managing memory, disk I/O, and network connections.

• They are essential for the proper functioning of the operating system and applications.

• Examples include the Oracle Database background processes, which manage database operations and maintain data consistency.

• They can be monitored and...read more

SMON, PMON, DBWR are background processes in Oracle DB. Dirty buffer is a buffer that has been modified but not yet written to disk.

• SMON (System Monitor) is responsible for cleaning up temporary segments and freeing up resources after a transaction is completed.

• PMON (Process Monitor) is responsible for cleaning up failed processes and releasing resources.

• DBWR (Database Writer) is responsible for writing modified buffer...read more

Views are virtual tables while Materialized views are physical tables.

• Views are created using SELECT statement while Materialized views are created using CREATE MATERIALIZED VIEW statement.

• Views are not stored physically while Materialized views are stored physically.

• Views are updated dynamically while Materialized views are updated manually or using a scheduled job.

• Materialized views are faster for read-intensive oper...read more

Yes, I have worked on Oracle Dataguard.

• I have experience in configuring and managing Oracle Dataguard for disaster recovery.

• I have performed switchover and failover operations to test the failover mechanism.

• I have monitored and resolved issues related to Dataguard synchronization and network connectivity.

• I have also worked on configuring Active Dataguard for read-only reporting purposes.