The current online undo tablespace is smutbsl the dba

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: o bring online a larger undo tablespace, smu_tbs2, while application users are performing DML. The current ONLINE undo tablespace is smu_tbsl . The DBA issues the following command: SQL>ALTER SYSTEM SET undo_tablespace = smu_tbs2; What happens? A. Because the database is operating in Automatic Undo Management (AUM) mode, Oracle will dynamically balance a new rollback usage request across segments in both smu_tbsl and smu_tbs2. B. All new transactions will use rollback segments in smu_tbs2, and any existing sessions with active transactions will get an ORA- 3113 : end-of-file on communication channel error. C. The ALTER SYSTEM command will fail if there are sessions with active transactions, so the DBA must have the database in restricted mode to perform the operation. D. All undo segments in the smu_tbsl tablespace will have v$rollstat.status = 'PENDING OFFLINE' until all existing transactions have been committed or rolled back. All new transactions will use smu_tbs2. E. In order for the application users not to be impacted by the maintenance operation, the DBA will need to dynamically change undo_managment = MANUAL in order for users to use rollback segment undo while the undo tablespace is modified. Actualtests.com - The Power of Knowing 1Z0-030 Answer: D Explanation: F. After the DBA issues the following command all undo segments in the smu_tbsl tablespace will have v$rollstat.status = 'PENDING OFFLINE' until all existing transactions have been committed or rolled back. All new transactions will use smu_tbs2. Incorrect Answers A: Oracle will not dynamically balance a new rollback usage request across segments in both smu_tbsl and smu_tbs2. All new transactions will use smu_tbs2. Running transactions in the smu_tb1 tablespace will have v$rollstat.status = 'PENDING OFFLINE'. B: Existing sessions with active transactions will not get an error: they will have v$rollstat.status = 'PENDING OFFLINE' until all existing transactions have been committed or rolled back. C: The ALTER SYSTEM command will fail. E: The DBA have not to dynamically change undo_managment = MANUAL. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-164 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 19-25 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 112: When adding a new master site in an Advanced Replication environment without quiescing replication activity, you can instantiate the database at the new master site by using one of two methods. Which two methods can be used to perform this step? (Choose two.) A. Perform change-based recovery on the new master site. B. Perform a cancel-based recovery on the new master site C. Perform a time-based recovery on the new master site. D. Transport the relevant tablespace set from the master definition site to the new master site. E. Perform an export using the FLASHBACK_SCN option on the master definition site and then import the dump file to the new master database. Answer: A, D Explanation: You can perform change-based recovery on the new master site or transport the relev...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online