Path Infotech Oracle Database Administrator Interview Questions and Answers

LNS stands for Log Network Server, responsible for transmitting redo data from the primary database to standby databases. MRP is Managed Recovery Process, used to apply redo data to standby databases.

• LNS is responsible for transmitting redo data from primary to standby databases

• MRP is used to apply redo data to standby databases for data recovery

• LNS and MRP are essential components of Oracle Data Guard for ensuring dat

SGA is a shared memory area that stores data and control information for Oracle instance. Shared pool is a part of SGA that stores SQL statements and data dictionary cache.

• SGA is a fixed size memory area allocated at instance startup

• SGA contains database buffer cache, redo log buffer, shared pool, etc.

• Shared pool stores frequently used SQL statements and data dictionary cache

• Shared pool can be resized dynamically using

Buffer cache stores frequently accessed data in memory. Old archive logs can be deleted using RMAN commands.

• Buffer cache is a portion of memory used to store frequently accessed data to reduce disk I/O

• Oracle automatically manages the buffer cache size based on system resources and workload

• To delete old archive logs in RMAN, use the DELETE ARCHIVELOG command with options like 'ALL' or 'COMPLETED BEFORE'

• Example: DELETE A...read more