The database data files for user data and index are

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: using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recovery strategy available in Oracle9i? A. Rebuild the index using the online option. B. Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C. Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D. Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again. Answer: C Explanation: You can use RMAN with Block Media Recovery to restore and recover only those blocks. It is not required to set the individual data file offline. BMR enables you to back up specific blocks in a datafile without taking the database offline. The default backup method is datafile media recovery. You use the new BLOCKRECOVER statement to perform BMR. Incorrect Answers A: With corrupted blocks you cannot rebuild the index. You need restore and recover these blocks. B: It is not required to take the individual data file offline to perform the blocks restore and recovery. D: It is not required to take the individual data file offline to perform the blocks restore and recovery. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 186 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 84-86 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 76: Which two data types can be converted to LOBs using an ALTER TABLE... MODIFY command? (Choose two.) A. RAW B. LONG C. VARCHAR D. LONG RAW Actualtests.com - The Power of Knowing 1Z0-030 Answer: B, D Explanation: Oracle9i simplifies the process of converting a LONG or LONG RAW column into a CLOB or BLOB column respectively. You use the ALTER TABLE ... MODIFY statement to change a LONG or LONG RAW column into a CLOB or BLOB column respectively. Incorrect Answers A: The ALTER TABLE ... MODIFY statement can only convert a LONG or LONG RAW to a CLOB or BLOB column respectively. It will not change a VARCHAR or a RAW column into a LOB column. D: The ALTER TABLE ... MODIFY statement will not change a VARCHAR or a RAW column into a LOB column. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 262-263 Chapter 5: Language Enhancements Oracle 9i New Features, Robert Freeman, p. 147 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 77: Your company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change? A. SELECT username,operation,sql_redo from V$logmnr_contents where operation='DDL'; B. SELECT username,operation,sql_redo from V$logmnr_logs where operation...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online