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

If I use netlib, will I find many other users to network with?

Explain the scenarios or situations under which progress database creates new index entry for a record?

Explain the necessary techniques to control deadlocks?

Describe the difference between data and database administration.

How do databases work?

Can you explain fourth normal form and fifth normal form ?

How do we select distinct values from a table?

What is the difference between a MESSAGEBOX and an ALERT ?

What are the two types of indexes and explain them in detail?

What is progress open edge?

What is join? Mention its types.

What do you mean by deadlock dbms?

For more Database Management Interview Questions Click Here