OCP Database Architecture & Configuration 2

Question 1

Which Oracle background process is responsible for writing modified data blocks from the buffer cache to datafiles?

Accepted Answer

DBWR

Answer

DBWR (Database Writer) writes dirty buffers from the buffer cache to datafiles on disk.

Question 2

What is the purpose of the UNDO tablespace in Oracle Database?

Accepted Answer

Store rollback information for active transactions

Answer

The UNDO tablespace stores before-image data needed to roll back transactions and provide read consistency.

Question 3

Which initialization parameter controls the total size of the System Global Area (SGA)?

Accepted Answer

SGA_TARGET

Answer

SGA_TARGET enables Automatic Shared Memory Management (ASMM) and sets the total SGA size.

Question 4

What does a checkpoint event accomplish in Oracle Database?

Accepted Answer

Updates datafile headers with the current SCN and signals DBWR to write dirty buffers

Answer

A checkpoint updates all datafile headers with the current checkpoint SCN and triggers DBWR to write dirty buffers to disk.

Question 5

In Oracle's multi-tenant architecture, which component hosts the application data for a pluggable database?

Accepted Answer

The PDB itself

Answer

Each PDB contains its own application data, local users, and objects independent of the CDB root.

(OCP) Oracle Certified Professional Practice Test