nerdexam
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)
  • A
    2% (1)
  • B
    8% (4)
  • C
    2% (1)
  • D
    77% (37)
  • E
    10% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-072 Practice