OCP-1Z0-051-Question Analysis-24th question

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 wocould allow storage of dates only in the dd-mon-yyyy format.
B. The CUST_CREDIT_VALUE column wocould allow storage of positive and negative integers.
C. The TRANS_VALIDITY column wocould allow storage of a time interval in days, hours, minutes, and seconds.
D. The CUST_STATUS column wocould allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.


Answer: BC


A: The TRANS_DATE field can only store data in dd-mon-yyyy format. (Error. The Date data type can be accurate to the second, for example, dd-mon-yyyy HH24: MI: SS)
B: The CUST_CREDIT_VALUE field can store positive integers and negative integers. (Correct)
C: The TRANS_VALIDITY field can store time periods including days, hours, minutes, And seconds (correct)
D: The CUST_STATUS field can store a maximum of 4000 characters. (Error. If the maximum value is not specified, an error is returned)


This question can see the previous question: http://blog.csdn.net/wjx515628/article/details/35623657