1Z0-006 Oracle Database Architecture 2

Question 1

Which SGA component stores the most recently executed SQL statements and their execution plans?

Accepted Answer

Shared pool

Answer

The shared pool contains the library cache, which stores parsed SQL statements and execution plans for reuse.

Question 2

What is the primary role of the PMON (Process Monitor) background process?

Accepted Answer

Cleaning up after failed user processes

Answer

PMON detects failed user processes and cleans up the cache and releases resources such as locks that the failed process held.

Question 3

In Oracle, which type of file records all changes made to the database and is critical for instance recovery?

Accepted Answer

Redo log files

Answer

Redo log files record all changes (redo entries) to the database and are used to recover committed transactions after a failure.

Question 4

What does the term 'Oracle instance' specifically refer to?

Accepted Answer

The combination of SGA and background processes

Answer

An Oracle instance is defined as the combination of the System Global Area (SGA) memory structure and the Oracle background processes.

Question 5

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

Accepted Answer

DBWn

Answer

DBWn (Database Writer) writes dirty (modified) buffers from the database buffer cache to the data files on disk.

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