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

Define fragmentation.

Is it good to save image in database?

What is erd?

Explain the Surrogate Key in DBMS.

Can files be stored in a database?

Can you copy the PROGRAM UNIT into an Object group ?

Do we consider null values the same as that of blank space or zero?

I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........

What is tuple and attribute?

Can an Alert message be changed at runtime ?

Explain the difference between a dynamic and materialized view.

What is normal form in dbms?

For more Database Management Interview Questions Click Here