The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:
USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?
A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
C. It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2.
D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
F. It returns an error because UNDOTBS2 is fixed size.
|
Download Printable PDF. VALID exam to help you PASS. |
 |