Topic : Undo Tablespace

How find the undo segments in the database?


Answer :

SQL> select segment_name; tablespace_name from dba_rollback_segs;

Show Answer Discuss

Which activity would generate less undo data?


  • INSERT
  • UPDATE
  • SELECT
  • DELETE

Answer :

INSERT

Show Answer Discuss