教学文章
Technology Exchange
热门课程
400电话

免费咨询热线
400-090-9964

教学文章

【2020年8月】Oracle OCP 062考试新题(-4题)CUUG内部题库

时间:2020-09-24 来源:

【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金牌名师亲自题库解析

版权所有@北京神脑资讯技术有限公司(CUUG,中国UNIX用户协会) Copyright ALL Rights Reserved 京ICP备11008061号-1

CUUG旗下网站:www.cuug.com.cn www.cuug.com oracle.cuug.com bbs.cuug.com www.cuug.net

电话:010-59426307 010-59426319 邮政编码:100089

地址:北京市海淀区北清路164号28-38号院