Answer b explanation closed database backup will not

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: anation: Closed database backup will not cause an additional generation of redo because this type of backup is just copying of closed datafiles on operation system level: it has nothing to do with redo logs. Incorrect Answers: A: Open database backup (hot backup) will cause redo log activity. C: Increased transactional activity in the database will generate additional redo log files. D: If you change the NOLOGGING mode on frequently updated tables to LOGGING redo logs will be definitely generated for these statements. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 585-591 Chapter 12: Overview of Backup and Recovery QUESTION 49: In the view V$DATAFILE_HEADER, what does value 'YES' in the 'FUZZY' column as specified? A. The data file is corrupted. B. The data file is in backup mode. C. The data file is locally managed. D. The data file is part of a read-only tablespace. Answer: B Explanation: During checkpoints the new online redo log sequence number is written to the headers of every datafile in Oracle, as well as to the control file. In addition to...
View Full Document

Ask a homework question - tutors are online