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