Oracle
1Z0-082 · Question #35
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?…
The correct answer is B. Set UNDO_TABLESPACE to UNDOTBS01 D. Make certain that the database operates in automatic undo management mode. See the full explanation below for the reasoning.
Administer Undo Data
Question
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.)
Options
- AAdd the SEGMENT SPACE MANAGEMENT AUTO clause
- BSet UNDO_TABLESPACE to UNDOTBS01
- CAdd the NOLOGGING clause
- DMake certain that the database operates in automatic undo management mode
- EAdd the ONLINE clause
How the community answered
(22 responses)- A5% (1)
- B77% (17)
- C5% (1)
- E14% (3)
Topics
#UNDO tablespace#UNDO_TABLESPACE parameter#automatic undo management#AUM
Community Discussion
No community discussion yet for this question.