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 A.D.
B, C
B, C
VARCHAR2 – maximum size must be specified
CHAR – default value is one
DATE – fixed-length, 7-byte field contains Century, Year, Month, Day, Hour, Minute, Second.
Thus, use the TIMESTAMP datatype which has fractional seconds.
Why B?
Because it is necessary indicate the length for this column, is a varchar2 data type