Oracle
1Z0-062 · Question #139
Examine the parameters for your database instance: You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.
Managing Undo Data
Question
Examine the parameters for your database instance:
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?
Options
- AUndo data is written to flashback logs after 1200 seconds.
- BInactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of
- CYou can perform a Flashback Database operation only within the duration of 1200 seconds.
- DAn attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#undo tablespace#UNDO_RETENTION#RETENTION NOGUARANTEE#undo management