1Z0-006 Oracle Database Architecture 3

Question 1

Which SGA component is allocated per-server and stores session-specific data such as sort areas and cursor state?

Accepted Answer

Program Global Area (PGA)

Answer

The PGA (Program Global Area) is private memory allocated for each server process, storing session-specific data like sort work areas and bind variable values.

Question 2

What happens to the redo log buffer entries when it is one-third full or a COMMIT is issued?

Accepted Answer

LGWR writes them to the redo log files

Answer

LGWR writes redo log buffer contents to the online redo log files when triggered by a COMMIT, when the buffer is one-third full, or every three seconds.

Question 3

Which Oracle startup mode allows the DBA to perform maintenance but prevents regular users from connecting?

Accepted Answer

OPEN RESTRICTED

Answer

OPEN RESTRICTED mode opens the database but limits access to users with the RESTRICTED SESSION privilege, allowing DBA maintenance tasks.

Question 4

What is the function of the CKPT (Checkpoint) process?

Accepted Answer

Updating data file headers and the control file with the latest checkpoint SCN

Answer

CKPT updates the headers of data files and the control file with the current checkpoint System Change Number (SCN) after a checkpoint event.

Question 5

In Oracle architecture, what is a segment?

Accepted Answer

A set of extents that store a specific type of database object

Answer

A segment is a set of extents allocated for a specific database object such as a table, index, or undo data within a tablespace.

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

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

1Z0-006 Oracle Database Architecture 3