What are the advantages of operating a database in ARCHIVELOG mode over operat

What are the advantages of operating a database in
ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Question Posted / guest

Answers were Sorted based on User's Feedback

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVE..

Answer / guest

Complete database recovery from disk failure is possible
only in ARCHIVELOG mode.

Online database backup is possible only in ARCHIVELOG mode.

Is This Answer Correct ?

6 Yes

0 No

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVE..

Answer / guest

More space is required when running in ARCHIVE_LOG mode,
however disk space is cheap.

Is This Answer Correct ?

2 Yes

2 No

More Database Management Interview Questions

Is it possible to use Transactional control statements in Database ?

Explain the advantages and disadvantages of a hierarchical database?

What is a database in a website?

Explain database partitioning and its importance.

What are the five steps of data modeling?

what are the advantages of using them.

Which dbms is best?

How to debug stored procedures?

How to handle data if f table are more than one and each table contain thousands of entries?

Explain about cursors?

What is rdbms and its types?

Is it possible to Enable or Disable a Database trigger ?

For more Database Management Interview Questions Click Here