Unformatted text preview: data file offline.
D: The alert log shows changing the database backup mode from NOARCHIVELOG to
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 663-666
Chapter 14: Database Failure and Recovery
Which two statements about the LogMiner utility are true? (Choose two)
A. It is implemented as a PL/SQL/SQL package.
B. It can only analyze and process achieved redo-log files.
C. The results of the LogMiner analysis are stored in an operating system text file.
D. It uses the information in the directory file to obtain the transaction system change
E. It translates the contents of the redo-log files into SQL undo commands to roll back
the original operations.
Answer: A, E
LogMiner utility is implemented as a PL/SQL / SQL package, it translates the contents of
the redo log files into SQL undo commands to roll back the original operations.
B: It can only process and analyze ONLINE redo log files.
C: The output from LogMiner is the contents of V$LOGMNR_CONT...
View Full Document
- Fall '09
- Jason S. Couchman, DBA Certification Exam, Certification Exam Guide