OCP Database Architecture & Administration 2

Question 1

Which Oracle background process is responsible for writing dirty buffers from the buffer cache to datafiles?

Accepted Answer

DBWR

Answer

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

Question 2

In Oracle's multi-tier memory architecture, which component stores the execution plans for recently parsed SQL statements?

Accepted Answer

Library cache

Answer

The library cache, which is part of the shared pool in the SGA, stores parsed SQL statements and their execution plans.

Question 3

What is the purpose of the CKPT background process in Oracle?

Accepted Answer

Updates datafile headers and control files with checkpoint information

Answer

CKPT updates the control file and datafile headers with checkpoint information, signaling that a checkpoint has occurred.

Question 4

Which Oracle data dictionary view shows the current size and usage of all tablespaces?

Accepted Answer

DBA_TABLESPACES

Answer

DBA_TABLESPACES provides information about all tablespaces including their status, block size, and extent management type.

Question 5

When a user issues a COMMIT, which Oracle process ensures the redo data is written to disk before the commit completes?

Accepted Answer

LGWR

Answer

LGWR (Log Writer) writes redo log buffer contents to the online redo log files at commit time, ensuring durability.

(OCP) Oracle Certified Professional Practice Test