Technology Exchange
免费咨询热线
400-090-9964
【2020年8月】Oracle OCP 062考试新题(-4题)CUUG内部题库
Choose two.
Examine these parameter settings:
NAME TYPE VALUE
-------------------- ----------- --------------------
undo_management string AUTO
undo_retention integer 900
Now examine this statement:
ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
Tablespace altered.
Which two are true about undo retention in this configuration?
A) Unexpired undo is retained for 900 seconds, only if free undo space is available.
B) Expired undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.
C) Undo data expires after 900 minutes.
D) Undo data is written to flashback logs after 900 seconds.
E) Active undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.
F) Unexpired undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.
2020年8月份Oracle OCP 062考试新题(-4题)CUUG内部题库,钉钉群(35277291)Oracle金牌名师亲自题库解析