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

24. 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 VARCHAR2 

TRANS_DATE             NOT NULL DATE

TRANS_VALIDITY                  INTERVAL DAY TO SECOND

CUST_CREDIT_VALUE               NUMBER(10)

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

A. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format. 

B. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers. 

C. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and

seconds. 

D. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000

characters.

Answer: BC