You need to create a table for a banking application. One of the columns in the table has the
following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and
subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit
for.
Which data type would you use for such a column in the table?
A.
DATE
B.
NUMBER
C.
TIMESTAMP
D.
INTERVAL DAY TO SECOND
E.
INTERVAL YEAR TO MONTH
Here is a great Blog You may Find Interesting that we encourage you to visit.
the time to study or visit the content or websites we’ve linked to below the
check below, are some entirely unrelated internet sites to ours, even so, they’re most trustworthy sources that we use
always a massive fan of linking to bloggers that I enjoy but really don’t get a whole lot of link really like from
that could be the end of this report. Here youll find some web pages that we feel you will enjoy, just click the hyperlinks over
one of our guests a short while ago advised the following website
just beneath, are many entirely not related websites to ours, nevertheless, they’re certainly really worth going over
the time to study or check out the content or web-sites we’ve linked to below the
below you will discover the link to some internet sites that we feel you must visit
Wonderful story, reckoned we could combine a few unrelated information, nonetheless truly worth taking a look, whoa did one particular master about Mid East has got far more problerms too
always a significant fan of linking to bloggers that I adore but really don’t get a great deal of link appreciate from
D
INTERVAL DAY TO SECOND type stores time intervals measured in days and seconds.