1Z0-006 Oracle Architecture & Tools 4

Question 1

What happens to the Program Global Area (PGA) when a user session terminates?

Accepted Answer

It is deallocated and the memory is returned to the OS

Answer

PGA memory is private to each server process; when that process ends (session terminates), its PGA is freed back to the operating system.

Question 2

Which Oracle background process performs instance recovery automatically when the database is restarted after a crash?

Accepted Answer

SMON

Answer

SMON (System Monitor) performs instance recovery at startup by applying redo logs to roll forward and then rolling back uncommitted transactions.

Question 3

What is the role of the Control File in an Oracle database?

Accepted Answer

Contains the binary record of the database structure including data file locations and log file history

Answer

The control file is a small binary file that records the database name, data file and redo log locations, checkpoint information, and RMAN backup history.

Question 4

In Oracle, what is Automatic Memory Management (AMM)?

Accepted Answer

A mode where Oracle automatically distributes memory between SGA and PGA based on workload

Answer

AMM allows Oracle to automatically tune the total memory (SGA + PGA) allocation between components based on current workload demand.

Question 5

Which file type stores the actual table rows and index data in an Oracle database?

Accepted Answer

Data files

Answer

Data files (.dbf) store the actual user data including table rows, index entries, and other database object data.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Oracle Architecture & Tools 4