🎴 Flashcard Mode
Oracle Database Administration
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Your database is in NOARCHIEVELOG mode. After which two operations you should take backup of control file? ( choose two)
AnswerClick to flip back
A
Adding a new tablespace to database.
B
Dropping a datafile from a tablespace.
💡 Explanation:
In NOARCHIVELOG mode, you cannot recover from backups after a structural change. Adding a tablespace changes the database structure permanently. Dropping a datafile from a tablespace is another structural change that cannot be recovered without a backup. Adding/dropping users or tables are data dictionary changes, not structural changes that require control file backup.