OCP CBT Question 689

Please solve the following question.

Which SQL statement can be used to determine if an Oracle database is currently running in ARCHIVELOG mode or NOARCHIVELOG mode?

ARCHIVELOG mode is crucial for database recoverability, allowing you to recover the database to any point in time by applying archived redo logs. NOARCHIVELOG mode limits recovery to the loss of only online redo logs.

SELECT LOG_MODE FROM V$ARCHIVE_STATUS;

SELECT ARCHIVELOG FROM V$INSTANCE;

SELECT LOG_MODE FROM V$DATABASE;

SELECT ARCHIVELOG_ENABLED FROM DBA_DATABASE_PROPERTIES;