1Z0-052 · Question #233
While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to…
The correct answer is E. schedule the database backup using Database Configuration Assistant (DBCA) while creating the. DBCA allows you to configure automatic backups for an Oracle database at the time of database creation, eliminating the need for post-creation manual scheduling.
Question
While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective?
Options
- Aconfigure the database to run in ARCHIVELOG mode
- Bconfigure the Flash Recovery Area to enable automatic database backup
- Cschedule the database backup using DBMS_JOB package after creating the database
- Dschedule the database backup using Recovery Manager (RMAN) commands after creating the
- Eschedule the database backup using Database Configuration Assistant (DBCA) while creating the
How the community answered
(31 responses)- B3% (1)
- C13% (4)
- D6% (2)
- E77% (24)
Why each option
DBCA allows you to configure automatic backups for an Oracle database at the time of database creation, eliminating the need for post-creation manual scheduling.
ARCHIVELOG mode enables archiving of redo log files for point-in-time recovery capability, but it does not itself schedule or perform database backups.
The Flash Recovery Area is a designated disk location for storing recovery-related files, not a mechanism for scheduling or automating database backups.
The DBMS_JOB package can schedule PL/SQL jobs including backup scripts, but this requires manual setup after the database is already created rather than during creation.
RMAN commands can perform and schedule backups, but configuring them after database creation requires manual steps and does not provide the automatic, creation-time setup the objective requires.
The Database Configuration Assistant (DBCA) includes a built-in option to schedule automatic backups during the database creation wizard by integrating directly with Oracle Recovery Manager. This allows you to configure backup frequency and storage location as part of the initial setup, so backups begin automatically without requiring any manual intervention after the database is created.
Concept tested: Oracle DBCA automatic backup configuration during database creation
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/creating-and-configuring-an-oracle-database.html
Topics
Community Discussion
No community discussion yet for this question.