What are the advantages of operating a database in
ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Answers were Sorted based on User's Feedback
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 |
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 |
How does a database store data?
How the status of the Rollback segment can be viewed ?
Explain the term generalization.
What is the structure of a table in database?
Describe two phases of Two-phase commit ?
What is the main difference between union and union all?
define aggregate functions.
How to improve query performance using index hunting?
Why is normalisation used?
What is the difference between SQL and NoSQL databases
What is information schema in database?
what are the advantages of using them.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)