hiexam
oracle · 1z0-062 · Q602 · multiple_choice · topic_1

Examine the parameters for your database instance: //IMG// You execute the following command: SQL> ALTER TABLESPACE un…

Examine the parameters for your database instance: //IMG// You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?
  • A.Undo data is written to flashback logs after 1200 seconds.
  • B.Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
  • C.You can perform a Flashback Database operation only within the duration of 1200 seconds.
  • D.An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
Explanation
B -> if RETENTION GRANTEE, it will let lack of space in the undo tablespace D -> NOGUARANTEE -> it won't have lack of space so it may overwrite THe answer is D

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.