Oracle
1Z0-072 · Question #31
In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA. Examine these parameters. NAME TYPE VALUE -------------------- -------- ------- TEMP_UNDO_ENABLED…
The correct answer is D. TEMP. See the full explanation below for the reasoning.
Question
In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA. Examine these parameters. NAME TYPE VALUE -------------------- -------- ------- TEMP_UNDO_ENABLED boolean TRUE UNDO_MANAGEMENT string AUTO UNDO_RETENTION integer 900 UNDO_TABLESPACE string UNDOTBS1 Which tablespace stores UNDO generated by USER1's DML on temporary tables?
Options
- ADATA
- BSYSTEM
- CSYSAUX
- DTEMP
- EUNDOTBS1
How the community answered
(48 responses)- A2% (1)
- B8% (4)
- C2% (1)
- D77% (37)
- E10% (5)
Community Discussion
No community discussion yet for this question.