1Z0-006 Oracle Architecture & Tools

Question 1

Which Oracle memory structure caches recently accessed data blocks?

Accepted Answer

Database Buffer Cache

Answer

Shared Pool

Answer

Large Pool

Answer

Redo Log Buffer

Question 2

The process responsible for writing redo entries from the redo log buffer to the online redo log files is:

Accepted Answer

LGWR

Answer

DBWn

Answer

ARCn

Answer

CKPT

Question 3

Which file records the physical structure of the database, including data file locations and log history?

Accepted Answer

Control file

Answer

Parameter file

Answer

Temp file

Answer

Password file

Question 4

Oracle SQL*Loader is primarily used to:

Accepted Answer

Load data from flat files into tables

Answer

Export schemas

Answer

Monitor sessions

Answer

Generate ER diagrams

Question 5

Data Pump Export (expdp) differs from the legacy EXPORT utility by:

Accepted Answer

Supporting parallel, direct-path export

Answer

Writing dumps in ASCII format

Answer

Operating only on client side

Answer

Requiring SQL*Net connectivity

Question 6

Enterprise Manager (EM) Express provides:

Accepted Answer

Graphical web interface for basic administration

Answer

Command-line interface only

Answer

Physical storage management only

Answer

Data modeling

Question 7

Automatic Storage Management (ASM) simplifies storage by:

Accepted Answer

Automating disk group management and striping

Answer

Replacing file system caching

Answer

Encrypting network traffic

Answer

Disabling direct I/O

Question 8

Which component parses and caches SQL execution plans in memory?

Accepted Answer

Library cache

Answer

Redo log buffer

Answer

Large pool

Answer

Java pool

Question 9

Oracle Net Listener’s primary role is to:

Accepted Answer

Accept and route incoming client connections

Answer

Schedule jobs

Answer

Manage archive logs

Answer

Encrypt tablespaces