oracle ocp 062是考什么,【2020年8月】Oracle OCP 062考试新题(-2题)CUUG内部题库

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

Choose the best answer.

Examine these parameter settings:

NAME TYPE VALUE

db_create_file_dest string /u01/app/oracle/oradata/prod/

undo_management string AUTO

undo_retention integer 900

undo_tablespace string UNDOTBS1

You execute this:

CREATE UNDO TABLESPACE UNDOTBS2 SEGMENT SPACE MANAGEMENT AUTO;

Which is true?

A) It fails because Automatic Segment Space Management (ASSM) is not supported for an UNDO TABLESPACE.

B) It fails because there is already an active UNDO TABLESPACE for the database instance.

C) It fails because size and data file clause are missing.

D) It executes successfully and space in the UNDOTBS2 tablespace will be freelist managed.

E) It executes successfully and space in the UNDOTBS2 tablespace will be bitmap managed.

2020年8月份Oracle OCP 062考试新题(-2题)CUUG内部题库，钉钉群(35277291)Oracle金牌名师亲自题库解析

文章来源: blog.51cto.com，作者：cto_5359，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.51cto.com/13854012/2541895