1Z0-006 Oracle Database Architecture 4

Question 1

What is an extent in Oracle's logical storage hierarchy?

Accepted Answer

A contiguous set of Oracle data blocks

Answer

An extent is a specific number of contiguous Oracle data blocks allocated at once to a segment when it needs to grow.

Question 2

Which component of the shared pool stores the Oracle data dictionary cache (row cache)?

Accepted Answer

Dictionary cache

Answer

The dictionary cache (also called the row cache) within the shared pool stores frequently accessed data dictionary information to avoid repeated disk reads.

Question 3

In a dedicated server configuration, how many server processes handle a single user session?

Accepted Answer

One dedicated server process per session

Answer

In dedicated server mode, Oracle spawns one dedicated server process exclusively for each user session for its entire duration.

Question 4

What is the System Change Number (SCN) used for in Oracle?

Accepted Answer

Providing a consistent ordering of database changes for recovery and read consistency

Answer

The SCN is Oracle's internal timestamp that uniquely orders database changes, enabling consistent reads and precise point-in-time recovery.

Question 5

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 rolling forward committed changes from redo logs and rolling back uncommitted transactions.

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

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

1Z0-006 Oracle Database Architecture 4