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

What is cursor and where do you use them?

Enlist the types of cursor?

What are the package used in DBMS ?

What is stored procedure in database?

What's the difference between star and snow flake schema?

Briefly describe the three types of sql commands.

What are the advantages of manual database?

What do database languages do?

What is a distributed database system?

Which database is best for storing large data?

Is it good to store image in database?

Explain what are super servers?

For more Database Management Interview Questions Click Here