1Z0-042 Oracle OCA: Database 10g Administration I — Complete Exam Guide

Quick-Prep for 1Z0-042: Oracle OCA Database 10g Administration I — Cheat Sheet

Scope (assumed)

Covers core 1Z0-042 topics for Database 10g Administration I: installation, instance architecture, storage structures, processes, memory, backup/restore basics, user/security, tablespaces, datafiles, control files, redo/archiving, basic performance views, Oracle Net, RMAN fundamentals, export/import, and basic OEM tasks.

One-page essentials

• Key commands

  • STARTUP | SHUTDOWN [IMMEDIATE|ABORT|TRANSACTIONAL]
  • CREATE DATABASE / ALTER DATABASE
  • CREATE CONTROLFILE SET DATABASE / ALTER DATABASE BACKUP CONTROLFILE TO TRACE
  • CREATE TABLESPACE … DATAFILE ‘…’ SIZE nM; ALTER TABLESPACE … ADD DATAFILE ‘…’ SIZE …
  • CREATE USER u IDENTIFIED BY p; GRANT CONNECT, RESOURCE TO u
  • CREATE/ALTER SYSTEM SET parameter = value SCOPE = [MEMORY|SPFILE|BOTH]
  • ALTER DATABASE ARCHIVELOG / NOARCHIVELOG
  • RECOVER DATABASE USING BACKUP CONTROLFILE; RMAN BACKUP/RESTORE/RECOVER

• Important views

  • V\(INSTANCE, V\)DATABASE, V\(PARAMETER, V\)SESSION, V\(PROCESS, V\)DATAFILE, V\(LOG, V\)CONTROLFILE, V\(TABLESPACE</li> </ul> </li> <li> <p><strong>Instance vs Database</strong></p> <ul> <li>Instance = SGA + background processes. Database = datafiles + control files + redo logs.</li> </ul> </li> <li> <p><strong>SGA components</strong></p> <ul> <li>Shared Pool (library cache + dictionary cache), Buffer Cache, Redo Log Buffer, Java Pool, Large Pool.</li> </ul> </li> <li> <p><strong>Background processes (common)</strong></p> <ul> <li>SMON, PMON, DBWR, LGWR, CKPT, ARCn</li> </ul> </li> <li> <p><strong>Tablespace types</strong></p> <ul> <li>Permanent, Temporary, Undo (in 10g undo tablespace replaces rollback segments)</li> </ul> </li> <li> <p><strong>Undo sizing factors</strong></p> <ul> <li>UNDO_RETENTION, transactions/sec (undo generation rate), size of undo blocks</li> </ul> </li> <li> <p><strong>Redo/Archiving basics</strong></p> <ul> <li>Online redo logs → LGWR writes; ARCH processes archive when in ARCHIVELOG mode. Use ALTER SYSTEM SWITCH LOGFILE and ARCHIVE LOG LIST.</li> </ul> </li> <li> <p><strong>Control file role</strong></p> <ul> <li>Stores DB structure metadata; must be multiplexed (multiple copies).</li> </ul> </li> <li> <p><strong>Backup/Restore fundamentals (RMAN)</strong></p> <ul> <li>RMAN: CONNECT TARGET; BACKUP DATABASE; RESTORE DATABASE; RECOVER DATABASE; CATALOG; CONFIGURE RETENTION POLICY.</li> <li>Cold backup (consistent) vs hot backup (online/inconsistent) require archiving or recovery.</li> </ul> </li> <li> <p><strong>Basic recovery scenarios</strong></p> <ul> <li>Lost datafile: RESTORE DATAFILE; RECOVER DATAFILE</li> <li>Lost control file: CREATE CONTROLFILE or restore from backup</li> <li>Instance crash: OPEN RESETLOGS after incomplete recovery if necessary</li> </ul> </li> <li> <p><strong>Performance and tuning basics</strong></p> <ul> <li>Use AWR/ADDM (if licensed) or Statspack; check wait events, buffer cache hit ratio, library cache locks.</li> <li>Use EXPLAIN PLAN; optimize by indexing and statistics (DBMS_STATS.GATHER_SCHEMA_STATS).</li> </ul> </li> <li> <p><strong>SQL*Loader / Data Pump / Export-Import</strong></p> <ul> <li>sqlldr for flat-file loads; exp/imp (10g) and Data Pump introduced in 10g (expdp/impdp).</li> </ul> </li> <li> <p><strong>Oracle Net / Listener</strong></p> <ul> <li>Listener.ora and Tnsnames.ora basics; use lsnrctl STATUS/START/STOP.</li> </ul> </li> <li> <p><strong>OEM (Enterprise Manager) basics</strong></p> <ul> <li>EM Database Control for monitoring, backups, and basic administrative tasks.</li> </ul> </li> </ul> <h3>Quick study checklist (7 items)</h3> <ol> <li>Install/startup/shutdown, instance states (NOMOUNT, MOUNT, OPEN) — practice commands.</li> <li>Create/alter tablespaces, add datafiles — practice file management.</li> <li>User/privilege management and roles — create sample users and grant privileges.</li> <li>Configure ARCHIVELOG and perform log switches, archive management.</li> <li>RMAN: run simple backup, restore a datafile, and perform recovery.</li> <li>Inspect V\) views for diagnostics and practice basic OEM tasks.
  • Practice sample multiple-choice questions covering undo sizing, temporary tables, parameter scopes, and startup states.

  Common exam traps

  • Confusing MOUNT vs OPEN (e.g., altering control files often requires MOUNT).
  • Undo vs rollback segments terminology (10g uses undo tablespace).
  • RMAN vs user-managed backups behavior and commands.
  • Scope of ALTER SYSTEM SET (MEMORY vs SPFILE).

  Quick reference table

  Topic	Command / Note
  Startup states	NOMOUNT (read init), MOUNT (control file), OPEN (datafiles open)
  Undo	UNDO tablespace, UNDO_RETENTION
  Backup types	Cold (consistent), Hot (online)
  RMAN essentials	BACKUP DATABASE; RESTORE; RECOVER
  Important views	V\(INSTANCE, V\)DATABASE, V\(PARAMETER, V\)DATAFILE

  If you want, I can convert this into a printable one-page PDF or produce 20 practice multiple-choice questions with answers.