24.Examine the structure proposed for the TRANSACTIONS table:

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.
答案：BC
解析：
A:错误，TRANS_DATE可以存储其他格式，只要修改默认的类型nls_data_format就可以了
B:正确，可以存储正数和负数
C:正确，
D:错误，这里varchar2可以在sql中存储的是4000个bytes，而不是characters，