OCP CBT Question 505

Please solve the following question.

You are managing an Oracle database. The database is currently running in NOARCHIVELOG mode. One of the datafiles belonging to the USERS tablespace is accidentally deleted from the operating system. You have an RMAN full backup taken three days ago.Which statement is true regarding the recovery options for this database?

sqlSELECT LOG_MODE FROM V$DATABASE;-- Output:-- LOG_MODE-- -------------- NOARCHIVELOG

You can recover the database to the point of the last full backup, but all transactions since the backup will be lost.

You cannot recover the database because NOARCHIVELOG mode does not allow any recovery from physical file loss.

You can perform a point-in-time recovery using the RMAN full backup and then apply archived redo logs generated since the backup.

You can recover the lost datafile individually to its most recent state using RMAN.