nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • B
    3% (1)
  • C
    13% (4)
  • D
    6% (2)
  • E
    77% (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.

Aconfigure the database to run in ARCHIVELOG mode

ARCHIVELOG mode enables archiving of redo log files for point-in-time recovery capability, but it does not itself schedule or perform database backups.

Bconfigure the Flash Recovery Area to enable automatic database backup

The Flash Recovery Area is a designated disk location for storing recovery-related files, not a mechanism for scheduling or automating database backups.

Cschedule the database backup using DBMS_JOB package after creating the database

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.

Dschedule the database backup using Recovery Manager (RMAN) commands after creating the

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.

Eschedule the database backup using Database Configuration Assistant (DBCA) while creating theCorrect

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

#DBCA#automated backup scheduling#backup configuration#database creation

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice