Oracle
1Z0-072 · Question #1
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. UNDOTBS2 is the active undo tablespace. Examine these commands: SQL> SELECT tablespace_name, status, retention FROM dba_tablespaces WHERE…
The correct answer is F. It returns an error because UNDOTBS2 is fixed size. See the full explanation below for the reasoning.
Question
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. UNDOTBS2 is the active undo tablespace. Examine these commands: SQL> SELECT tablespace_name, status, retention FROM dba_tablespaces WHERE tablespace_name LIKE 'UNDO%'; TABLESPACE_NAME STATUS RETENTION -------------------- ------- --------- UNDOTBS1 ONLINE NOGUARANTEE UNDOTBS2 ONLINE GUARANTEE SQL> SELECT tablespace_name, autoextensible, bytes/1024/1024 "SIZE" FROM dba_data_files WHERE tablespace_name LIKE 'UNDO%'; TABLESPACE_NAME AUTOEXTENSIBLE ---------- ---------- UNDOTBS1 YES 70 UNDOTBS2 NO 2 USER1 executes DML, which generates more than 2 MB of UNDO. What is the result and why?
Options
- AIt suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
- BIt returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
- CIt suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
- DIt returns an error because UNDOTBS2 has RETENTION GUARANTEE.
- EIt suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
- FIt returns an error because UNDOTBS2 is fixed size.
How the community answered
(28 responses)- A4% (1)
- C4% (1)
- D11% (3)
- F82% (23)
Community Discussion
No community discussion yet for this question.