1Z0-052 · Question #203
You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?
The correct answer is D. Enterprise Manager to schedule the backup. Enterprise Manager is the recommended Oracle tool for configuring, scheduling, and automating offline database backups through its built-in backup and recovery wizard.
Question
You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?
Options
- AThe XML script
- BThe PL/SQL script
- CThe DBMS_SCHEDULER package
- DEnterprise Manager to schedule the backup
How the community answered
(21 responses)- A10% (2)
- C5% (1)
- D86% (18)
Why each option
Enterprise Manager is the recommended Oracle tool for configuring, scheduling, and automating offline database backups through its built-in backup and recovery wizard.
XML scripts are not a standard Oracle backup scheduling mechanism; Oracle's backup automation relies on RMAN command files or OEM, not raw XML.
PL/SQL scripts can call DBMS_SCHEDULER to run OS commands, but they cannot natively invoke RMAN offline backup operations without additional OS-level scripting, making them unsuitable as the primary tool for this purpose.
DBMS_SCHEDULER can schedule arbitrary jobs but does not have built-in knowledge of RMAN backup procedures; it would require wrapping an external RMAN script and does not provide the integrated configuration that OEM offers for offline backups.
Oracle Enterprise Manager (OEM) provides a GUI-driven backup scheduler that integrates directly with RMAN, allowing DBAs to define offline (closed) backup jobs, set recurrence schedules, and monitor job history without writing scripts. It is the Oracle-recommended approach for automating cold backups in certification exam contexts because it combines RMAN's backup engine with a point-and-click scheduling interface.
Concept tested: Scheduling automated offline database backups with Enterprise Manager
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/getting-started-rman.html
Topics
Community Discussion
7
Prof. SaraJun 27, 2026The correct answer is D, Enterprise Manager, and this is one of those questions where the exam is testing whether you know which tool handles the full end-to-end backup workflow, not just scheduling in isolation. Enterprise Manager gives you a guided interface to configure RMAN backup settings, choose your backup type including offline or closed database backups, and then schedule those jobs to run automatically on a defined cadence, all from one place. Option C, DBMS_SCHEDULER, is a legitimate Oracle scheduling engine and you will absolutely see it on this exam in other contexts, but it does not natively configure the backup parameters the way EM does, so pairing it with offline backup setup in a single workflow is not the right fit here. Remember the mnemonic EM-BOSS: Enterprise Manager is your Backup and Operations Scheduling Solution, and whenever a question on 1Z0-052 mentions automating a complete backup routine through a management interface, EM is almost always where the exam wants you to land.
Ola B.Jun 27, 2026Enterprise Manager is the right call here, because it gives you a GUI-driven way to configure RMAN backup settings and point them at a schedule without writing a single line of script. Spin up a test database in VirtualBox or even Oracle Cloud Free Tier and walk through the Maintenance tab in EM Database Control yourself, that hands-on click-through sticks way better than memorizing an answer.
Luis F.Jun 27, 2026Enterprise Manager is the go-to tool here for scheduling offline backups through its GUI, though I remember getting tripped up on this one because DBMS_SCHEDULER sounds so tempting when you hear "schedule" and "automatic." Are you clear on why DBMS_SCHEDULER alone does not handle the actual backup configuration side of things, or is that part still fuzzy?
Hiroshi T.Jun 27, 2026DBMS_SCHEDULER can invoke an RMAN script or OS job, but the backup policy itself, the channel configuration, retention rules, and device type, still lives in RMAN or Enterprise Manager, so the scheduling mechanism and the backup configuration are two separate concerns that the exam blueprint treats distinctly in the Oracle Database Administration guide.
Mateus R.Jun 26, 2026C is the sneaky trap here because DBMS_SCHEDULER absolutely can fire off a job on a timer, the same way a kitchen timer can remind you to check the oven, but it does not actually know how to cook the meal, meaning it has no built-in knowledge of backup configuration, retention policies, or the RMAN settings you need to wire up before the schedule even matters. Enterprise Manager is the answer because it hands you a single workbench where you configure the backup strategy and set the recurring schedule together, so D is your pick.
Hiroshi T.Jun 27, 2026The XML script is the right pick here because Oracle's RMAN configuration stores backup settings in XML-based script files that can be written, saved, and handed off to the OS scheduler, which is exactly what offline automated backups require. The question asks specifically about scheduling offline backups to run automatically, and the XML script approach is what Oracle documents as the mechanism for defining those reusable backup configurations outside of an interactive session.
Mateus R.Jun 27, 2026Hiroshi, RMAN does not use XML for its script files, it uses its own command syntax saved in plain text files that the OS scheduler calls directly, which is exactly what option D describes. Think of it like leaving a written recipe on the counter for a cook who starts work before you wake up, and the OS scheduler is that cook who runs the recipe on a set clock, no interactive session needed.