D the alert log shows changing the database backup

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: data file offline. D: The alert log shows changing the database backup mode from NOARCHIVELOG to ARCHIVELOG. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 663-666 Chapter 14: Database Failure and Recovery QUESTION 103: 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 number. E. It translates the contents of the redo-log files into SQL undo commands to roll back the original operations. Answer: A, E Explanation: 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. Incorrect Answers: 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

Ask a homework question - tutors are online