Examine the structure proposed for the transactions table:
Which two statements are true regarding the creation and storage of data in the above table structure?
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
Explanation:
VARCHAR2(size)Variable-length character data (A maximum size must be specified: minimum size is 1;
maximum size is 4, 000.)
CHAR [(size)] Fixed-length character data of length size bytes (Default and minimum size is 1; maximum size is
2, 000.)
NUMBER [(p, s)] Number having precision p and scale s (Precision is the total number of decimal digits and
scale is the number of digits to the right of the decimal point; precision can range from 1 to 38, and scale can
range from –84 to 127.)
DATE Date and time values to the nearest second between January 1, 4712 B.C., and December 31, 9999