Mastering 1Z0-045: Practice Questions for Oracle Database 10g New Features (Oracle8i OCPs)Preparing to move from Oracle8i OCP to Oracle Database 10g requires focused study on features introduced in 10g and clear understanding of how those features differ from—or extend—Oracle8i behavior. This article guides you through an effective study plan built around practice questions, explains the core 10g features you must know, shows how to analyze and learn from practice-item mistakes, and provides a selection of representative practice questions with detailed explanations to cement learning.
Why focus on practice questions?
Practice questions do more than test recall — they train exam thinking patterns, expose gaps in applied knowledge, and help you internalize new feature behavior through active problem solving. For a technical transition exam such as 1Z0-045, well-crafted practice items:
- Highlight commonly-tested feature differences between Oracle8i and 10g.
- Force you to apply concepts (SQL, PL/SQL, backup/recovery, performance tuning, manageability) rather than memorize facts.
- Provide a timed environment to build exam pacing and stress-management skills.
Study approach and structure
- Diagnostic phase (1–2 days)
- Take a full-length practice test to identify weak areas.
- Record topics missed and categorize by concept type (syntax, behavior change, administration task).
- Focused study cycles (2–3 weeks)
- Cycle through the major topic areas: new 10g features, SQL/PLSQL changes, administration and manageability, backup/recovery, performance and optimizer behavior, and security changes.
- For each topic, alternate reading documentation with solving 8–12 practice questions.
- Intensive review (last 3–5 days)
- Re-take full practice exams, focus on timing.
- Review detailed explanations for every incorrect answer and for any question guessed.
- Exam-day readiness
- Rest well the night before; review concise cheat-sheet notes (feature differences, syntax examples, default behaviors).
Core Oracle Database 10g features to master
Below are the primary 10g features and changes you should know for 1Z0-045. For each item, practice questions typically probe practical behavior, syntax differences, or administrative implications.
Automatic Storage Management (ASM)
- Purpose: Simplify database file storage by providing volume manager and file system capabilities tuned for Oracle.
- Key points: disk groups, ASM instances (no database), ASM files vs. traditional file locations, ASM rebalancing.
- Typical question focus: creating disk groups, naming conventions, effect of adding/removing disks, interaction with RMAN.
Automatic Shared Memory Management (ASMM)
- Purpose: Simplify SGA component sizing with SGA_TARGET (and later PGA aggregate targets).
- Key points: SGA_TARGET parameter, dynamic resizing, interplay with manual sizing.
- Typical question focus: what happens when SGA_TARGET is adjusted; precedence rules with individual component parameters.
Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
- Purpose: Built-in performance data collection and automated analysis/diagnostics.
- Key points: snapshots, retention, ADDM reports and recommendations.
- Typical question focus: interpreting AWR/ADDM outputs and scheduling snapshots.
Flashback technologies
- Purpose: Provide fast, point-in-time data recovery options without traditional restore/recovery operations.
- Key points: Flashback Query, Flashback Table, Flashback Drop (recycle bin), Flashback Database (requires flash recovery area).
- Typical question focus: prerequisites, differences between flashback options, recovery scenarios where flashback cannot be used.
Flash Recovery Area (FRA)
- Purpose: Centralized disk location for backups, archived logs, flashback logs, and other recovery-related files.
- Key points: configuration with DB_RECOVERY_FILE_DEST and size, space management, RMAN integration.
- Typical question focus: auto-deletion policies, what files reside in FRA, behavior when FRA fills.
RMAN enhancements
- Purpose: Improved backup management and integration with new 10g features.
- Key points: block-change tracking, image copies vs. backup sets, integration with FRA, improved reporting.
- Typical question focus: RMAN commands for various scenarios, block-change tracking usage, incrementals and incremental-forever strategies.
SQL and PL/SQL enhancements
- Purpose: New syntax and functions that affect code migration from Oracle8i.
- Key points: new optimizer hints, new data types and functions, enhancements in PL/SQL (fine-grained dependency tracking, native compilation later).
- Typical question focus: behavior changes in optimizer, new built-in functions, and dependency handling.
Optimizer and performance improvements
- Purpose: Improved query optimizer behavior and statistics handling.
- Key points: automatic statistics gathering, histograms, optimizer modes, SQL plan management foundations.
- Typical question focus: when stats are collected, effect of changing optimizer parameters, plan stability considerations.
Enterprise Manager 10g (Grid Control and Database Control)
- Purpose: Centralized GUI management, monitoring, and performance diagnostics.
- Key points: DB Control for single DB, Grid Control for multi-DB environments, metric and alerting capabilities.
- Typical question focus: tasks that are simplified or available via EM, starting/stopping services via EM, job scheduling.
Security changes
- Purpose: Security enhancements and new default behaviors.
- Key points: new password management features, roles and privileges nuances, network encryption features added/enhanced.
- Typical question focus: recommended security settings, implications of default behaviors.
How to use practice questions effectively
- Emulate exam conditions: timed sessions, no notes, single question focus.
- After each question, read explanations thoroughly — not just the correct option but why other options fail.
- Keep an error log: for each missed question note topic, root cause, correct reasoning, and a short remedial action (example command, concept summary).
- Group weak-topic questions and re-test after focused review.
Representative practice questions (with answers and explanations)
- Question — ASM disk group creation: You want to create an ASM disk group named DATA_DG with redundancy EXTERNAL using three raw disks. Which is required? A. An ASM instance must be running and disk devices must be labeled with ASMLABEL. B. The database instance must be shut down and ASM mounted the disks. C. The disks must be managed by Oracle Clusterware. D. The disk devices must be formatted with UFS.
Answer: A. An ASM instance must be running and disk devices must be labeled with ASMLABEL.
Explanation: ASM requires an ASM instance to be running; raw disks must be prepared (udev or ASMLib/ASMLABEL) so ASM recognizes them. Oracle Clusterware is not required for single-instance ASM; UFS formatting is not applicable.
- Question — Flashback Table limitations: Which condition prevents Flashback Table from working? A. Table moved to a different tablespace via ALTER TABLE… MOVE after the flashback point. B. Table has an enabled row-level security (VPD) policy. C. Table contains LONG columns. D. Flashback Table cannot work if archived logs are unavailable.
Answer: A. Table moved to a different tablespace via ALTER TABLE… MOVE after the flashback point.
Explanation: Flashback Table relies on ROWIDs and segment metadata. Moving a table changes its physical storage and invalidates the ability to rewrite using flashback. Presence of LONG columns or VPD doesn’t inherently block flashback; archived logs availability is relevant for Flashback Database, not Flashback Table.
- Question — SGA_TARGET behavior: You set SGA_TARGET to 512M but leave individual component sizes unspecified. What happens? A. Oracle automatically divides the SGA_TARGET among components and dynamically resizes them as needed. B. Oracle ignores SGA_TARGET unless each component is explicitly set. C. The database will not start because individual parameters are required. D. SGA_TARGET only affects PGA.
Answer: A. Oracle automatically divides the SGA_TARGET among components and dynamically resizes them as needed.
Explanation: SGA_TARGET enables Automatic Shared Memory Management; Oracle distributes memory among the SGA components and can resize them dynamically.
- Question — AWR snapshots: Which statement about AWR snapshots is true? A. AWR snapshots are collected only manually. B. By default, AWR keeps snapshots forever. C. Automatic snapshots are taken at regular intervals and retention is configurable. D. AWR replaces all use of Statspack.
Answer: C. Automatic snapshots are taken at regular intervals and retention is configurable.
Explanation: AWR collects snapshots on a schedule (default hourly) and retention is configurable (default 8 days). Statspack still exists but AWR provides more integrated functionality.
- Question — RMAN block change tracking: Block change tracking is enabled to speed incremental backups. Which is true? A. It must be enabled in the control file and increases backup size. B. It is enabled with ALTER DATABASE ENABLE BLOCK CHANGE TRACKING and stores tracking info in a file. C. It replaces checksums for datafile validation. D. It is only available in RAC environments.
Answer: B. It is enabled with ALTER DATABASE ENABLE BLOCK CHANGE TRACKING and stores tracking info in a file.
Explanation: Block change tracking is enabled and records changed-block bitmap information in a file to speed incremental backups. It does not replace checksums and is available for single-instance databases as well.
Common pitfalls and how to avoid them
- Relying only on memorization: practice items should force application.
- Skipping exam objectives that seem “administrative”: many questions test practical DBA tasks.
- Ignoring error-message behavior: know typical errors for misconfiguration (e.g., FRA full, ASM mislabels).
- Not practicing timed tests: pacing mistakes cost points.
Additional study resources and tools
- Official Oracle 10g documentation (focus on New Features and Administration guides).
- AWR and ADDM reports on sample or lab databases.
- RMAN labs: configure FRA, do full and incremental backups, test restores.
- Hands-on ASM practice: create disk groups and move files to ASM.
Final practice checklist
- Understand ASM concepts and how to prepare disks.
- Know SGA_TARGET/ASMM behavior and precedence rules.
- Be able to interpret AWR/ADDM outputs and snapshot management.
- Master flashback features and their prerequisites/limitations.
- Practice RMAN commands: configure FRA, block-change tracking, perform restores.
- Review SQL/PLSQL changes and optimizer behavior introduced in 10g.
Mastering 1Z0-045 is a mix of hands-on practice, targeted reading, and disciplined use of practice questions. Use the sample items above as templates: after answering each question, write a one-line rationale for your choice and one example command or configuration you’d use in real life. Good luck.