1.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?
A. Undo data is written to flashback logs after 1200 seconds.
B. Inactive undo data isretained 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
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 isretained 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
答案:D
A:undo_retention u
ndo段数据在非Active状态之后,会保留1200秒。
B:在undo_retention时间内仍然会被覆盖。
C:在undo 没有覆盖的情况下 仍然可以恢复出几小时以前的数据。
一边把自己的想法写出来,一边学习,如果有错误的地方 还请各位见谅。