Examine the structure proposed for the TRANSACTIONS table:
Which statements are true regarding the creation and storage of data in the above table structure?
(Choose all that apply.)
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.
Option “D” is also true right?
wrong, becasue it can allow storage of time interval in days, hours, minutes,
and seconds.
D is incorrect. You do not need to specify length for NUMBER.
create table aaa (kol1 number);
insert into aaa values(22.8);
select * from aaa;
KOL1
———-
22.8