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

Choose two.

Examine the description of the PRODUCTS table which contains data:

Name Null? Type


PROD_ID NOT NULL NUMBER (2)

PROD_NAME VARCHAR2 (20)

EXPIRY_DATE NOT NULL DATE

Which two are true?

A) The PROD_NAME column cannot have a DEFAULT clause added to it.

B) The EXPIRY_DATE column data type can be changed to TIMESTAMP.

C) The PROD_ID column can be renamed.

D) The PROD_ID column data type can be changed to VARCHAR2 (2).

E) The EXPIRY_DATE column cannot be dropped.

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