Oracle
1Z0-072 · Question #1
1Z0-072 Question #1: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-072 to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-072 to see the answer
You've previewed enough free 1Z0-072 questions. Unlock 1Z0-072 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.