Oracle Database 12c: Advanced Administration — Question 22

Which three types of backups can be performed for a database running in NOARCHIVELOG mode?

Answer options

• A. consistent whole database backup
• B. backup of noncritical tablespaces without shutting down the instance
• C. backup of the database without shutting down the instance
• D. backup of only those blocks that have changed since the last backup while database is mounted
• E. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open

Correct answer: A, C, D

Explanation

The correct answers are A, C, and D because in NOARCHIVELOG mode, a consistent whole database backup can be performed, as well as a backup of the database without requiring a shutdown. Additionally, backing up changed blocks while the database is mounted is also possible. Option B is incorrect because it refers to noncritical tablespaces, which cannot be backed up without shutting down in this mode, and option E is incorrect as it suggests backing up used blocks while the database is open, which is not feasible in NOARCHIVELOG mode.