Multiple choice technology programming languages

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, database structural modifications such as adding a new tablespace or dropping a datafile alter the control file's structure. Backing up the control file immediately after these operations is critical since transactions are not archived, making recovery of structural changes impossible without a recent control file backup.

Keep practicing — related questions