Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 24191 Views
- I also Faced
- E-Mail Answers
Answer Posted / basobdutta
Archivelog mode - In archivelog mode cold and hot backups
are possible. We can recover our database upto the last
point of failure.
Noarchivelog mode- Here we can only go for cold
backup.Generally in this mode complete recovery is not
possible
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
how can you create a user-defined lock?
Where do you find the default index fill factor and how to change it? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What types of replication are supported in sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What are the recovery models for a database? : sql server DBA
How to start SQL Server in minimal configuration mode?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you schedule a job in database?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How do you trace the traffic hitting a sql server? : sql server DBA
