Q11. Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?

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

• (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