1z0-063 Exam QuestionsBrowse all questions from this exam

1z0-063 Exam - Question 180


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

Show Answer
Correct Answer: ABD

For a database running in NOARCHIVELOG mode, backups can be performed under certain conditions. A consistent whole database backup can be done when the database is shut down cleanly, ensuring that all changes are written to disk, making option A correct. It's possible to back up noncritical tablespaces without shutting down the instance, as these are not critical to the core operation of the database, making option B correct. Backup of only those blocks that have changed since the last backup while the database is mounted can also be performed, which is option D. Option C is incorrect because in NOARCHIVELOG mode, the database needs to be shut down, and option E is incorrect because only the used blocks in critical tablespaces cannot be backed up while the database is open.

Discussion

5 comments
Sign in to comment
alipilot2006
Apr 26, 2019

The answer is "ABD"

taiyang
Jul 28, 2020

ABD,too

badguy001djh
May 12, 2021

ABD is correct. Tablespace in offline status can be backup with rman when database is running in noarchivelog mode.

Kalinos20
Feb 3, 2020

Answer AD

KatieT
Apr 14, 2022

I think it's ACD. C because the "instance" does not need to be shutdown.

chris1
Feb 21, 2021

Only A and D are correct

ErikJanssen
Mar 23, 2021

I think answer A only; D is not correct because NOARCHIVELOG databases can only be backed up if shutdown.

arbol1
Dec 20, 2022

D is OK while database is mounted