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

How index hunting contributes in improving the query performance?

What are the parts of a table?

what is ORACLE CLINICAL What are the uses of Oracle clinical

How is data stored in a relational database?

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

Should database table names be capitalized?

Define ddl and dml.

Explain all codd's rules for relational database system?

How do you invoke datastage using unix?

What is key dbms?

How do you pass values from one form to another form ?

What is the use of database management system?

For more Database Management Interview Questions Click Here