Tag Archives: AUTOEXTEND

Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Add the SEGMENT SPACE MANAGEMENT AUTO clause C. Add the ONLINE clause D. Add the NOLOGGING clause E. Make certain that the database operates in automatic… Read More »

Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Make certain that the database operates in automatic undo management mode C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Add… Read More »