Multiple choice technology databases

Your database is in NOARCHIEVELOG mode. After which two operations you should take backup of control file? ( choose two)

  1. Adding a new user to database.

  2. Adding a new tablespace to database.

  3. Dropping a table from the database.

  4. Dropping a user from the database.

  5. Dropping a datafile from a tablespace.
Reveal answer Fill a bubble to check yourself
B,E Correct answer
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.

Keep practicing — related questions