1Z0-082 practice question 19 of 25

Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE ‘undotbs_01.dbf’ SIZE 100M AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

Full set: 142 questions
Answer options
A: Add the SEGMENT SPACE MANAGEMENT AUTO clause
B: Set UNDO_TABLESPACE to UNDOTBS01 Correct answer
C: Add the NOLOGGING clause
D: Make certain that the database operates in automatic undo management mode Correct answer
E: Add the ONLINE clause
Correct Answer:
B. Set UNDO_TABLESPACE to UNDOTBS01; D. Make certain that the database operates in automatic undo management mode
Explanation

For an undo tablespace to become the database’s default, the instance must be running in Automatic Undo Management (AUM) mode (UNDOMANAGEMENT = AUTO) and the initialization parameter UNDOTABLESPACE must be set to the new tablespace’s name (UNDOTBS01). Merely creating the tablespace with CREATE UNDO TABLESPACE is insufficient; these two parameter settings are mandatory.

Why Incorrect

A – SEGMENT SPACE MANAGEMENT AUTO applies to regular tablespaces; undo tablespaces ignore this clause. C – NOLOGGING is disallowed for undo tablespaces (Oracle returns ORA-30022). E – ONLINE is the default for CREATE UNDO TABLESPACE and does not make it the default undo tablespace.

References

1. Oracle Database Concepts 19c

“Managing Undo”

Sec. 13.3.3 “Setting Up Automatic Undo Management” – requirement for UNDOMANAGEMENT = AUTO and UNDOTABLESPACE.

2. Oracle Database SQL Language Reference 19c

“CREATE UNDO TABLESPACE” syntax – notes on default ONLINE and disallowed NOLOGGING

Doc ID F17309-04.

Scroll to Top