Which statements are true regarding the creation and storage of data in the above table structure?

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.)

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


reach

reach

Option “D” is also true right?

dj

dj

wrong, becasue it can allow storage of time interval in days, hours, minutes,
and seconds.

Justyna

Justyna

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