OCP Database Architecture & Configuration

Question 1

What is the role of the Oracle SGA (System Global Area)?

Accepted Answer

To store shared memory for Oracle processes

Answer

The Oracle System Global Area (SGA) is a fundamental component of an Oracle database instance, serving as a shared memory region. It stores critical data structures and control information, such as the database buffer cache, redo log buffer, and shared pool. These areas are accessible by all server processes and background processes, enabling efficient data access and communication within the database.

Question 2

What is the purpose of the Oracle instance?

Accepted Answer

It manages the database's processes and memory

Answer

An Oracle instance is a combination of the System Global Area (SGA) and the background processes that access the database files. It acts as the interface between users and the physical database, managing all database operations, memory allocation, and process execution. Without an instance, the database files cannot be accessed or manipulated.

Question 3

Which Oracle process is responsible for performing background database tasks like recovery and managing transactions?

Accepted Answer

DBWR

Answer

The Database Writer (DBWR) background process is responsible for writing modified data blocks from the database buffer cache to the data files on disk. This process ensures that changes made in memory are persistently stored, managing the flow of data from the volatile memory to stable storage. While SMON and PMON are also background processes, DBWR specifically handles writing dirty buffers.

Question 4

What is the Oracle Redo Log used for?

Accepted Answer

To track the changes to the database for recovery

Answer

The Oracle Redo Log is a crucial component for database recovery and ensuring data integrity. It records all changes made to the database, including transactions, DDL operations, and internal database actions. In case of an instance failure, the redo log files are used to reconstruct committed transactions and recover the database to its most recent consistent state.

Question 5

What is the Oracle Archive Log Mode?

Accepted Answer

It allows point-in-time recovery

Answer

Oracle Archive Log Mode enables the database to retain copies of filled redo log files, known as archived redo logs. This is critical for performing point-in-time recovery, allowing the database to be restored to any specific moment in time, even after a complete loss of data files. Without archive log mode, recovery is limited to the last full backup, potentially losing recent transactions.

(OCP) Oracle Certified Professional Practice Test

(OCP) Oracle Certified Professional Practice Test

OCP Database Architecture & Configuration