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

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?

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.



Leave a Reply 1

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


Jimmy

Jimmy

Answer B and C
varchar2 needs () with a number and CHAR without the brackets will just create a one char entry.
A is wrong, as it can be created.
D is wrong NUMBER without precision will just enter the value as given
E is wrong because it can not be created as such
F is wrong fractions of seconds cannot be stored