1Z0-006 Oracle Architecture & Tools 3

Question 1

Which component of the Oracle SGA stores information about database objects such as table definitions and user privileges?

Accepted Answer

Data Dictionary Cache

Answer

The Data Dictionary Cache (part of the Shared Pool) stores metadata about database objects, reducing repeated reads of the data dictionary from disk.

Question 2

What is the function of the ARCH (Archiver) background process?

Accepted Answer

Copies filled online redo log files to archive log destinations

Answer

The ARCH process copies online redo log files to one or more archive destinations when the database runs in ARCHIVELOG mode.

Question 3

What does SQL*Plus primarily allow a DBA or developer to do?

Accepted Answer

Execute SQL and PL/SQL statements interactively from a command line

Answer

SQL*Plus is Oracle's command-line interface for running SQL queries, PL/SQL blocks, and administrative commands against an Oracle database.

Question 4

When a checkpoint occurs in Oracle, which process is signaled to write dirty buffers to disk?

Accepted Answer

DBWR

Answer

During a checkpoint, the CKPT process signals DBWR to write all dirty buffers to disk, then updates the control file and data file headers with the checkpoint position.

Question 5

Which Oracle memory area is used for large operations such as parallel query buffers and RMAN backup/restore I/O?

Accepted Answer

Large Pool

Answer

The Large Pool is an optional SGA area that provides large memory allocations for parallel execution, RMAN, and shared server session memory.

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

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

1Z0-006 Oracle Architecture & Tools 3