OCP-1Z0-051-V9.02-23题

23. Examine the structure proposed for the TRANSACTIONS table:

name                    Null      Type

TRANS_ID               NOT NULL NUMBER(6) 

CUST_NAME              NOT NULL VARCHAR2(20) 

CUST_STATUS            NOT NULL CHAR 

TRANS_DATE             NOT NULL DATE 

TRANS_VALIDITY                  VARCHAR2 

CUST_CREDIT_LIMIT               NUMBER 

Which statements are true regarding the creation and storage of data in the above table structure?

(Choose all that apply.)

A. The CUST_STATUS column would give an error.

B. The TRANS_VALIDITY column would give an error.

C. The CUST_STATUS column would store exactly one character.

D. The CUST_CREDIT_LIMIT column would not be able to store decimal values.

E. The TRANS_VALIDITY column would have a maximum size of one character.

F. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds,

and fractions of seconds.