Oracle Database Administration I — Question 168

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.)

Answer options

• A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
• B. Set UNDO_TABLESPACE to UNDOTBS01
• C. Add the NOLOGGING clause
• D. Make certain that the database operates in automatic undo management mode
• E. Add the ONLINE clause

Correct answer: B, D

Explanation

To set UNDOTBS01 as the default UNDO tablespace, you must assign it to the UNDO_TABLESPACE parameter (option B) and verify that the database is configured for automatic undo management (option D). The other options, while relevant to tablespace management, do not directly influence the default setting for the UNDO tablespace.