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 TRANS_VALIDITY column would give an error.
B.
The TRANS_VALIDITY column would have a maximum size of one character.
C.
The TRANS_DATE column would be able to store day, month, century, year, hour,
minutes, seconds, andfractions of seconds.
D.
The CUST_STATUS column would store exactly one character.
E.
The CUST_STATUS column would give an error.
F.
The CUST_CREDIT_LIMIT column would not be able to store decimal values.
Check Sayed’s comment here:
http://www.aiotestking.com/oracle/which-two-statements-are-true-regarding-the-creation-and-storage-of-data-in-the-above-table-structure/
Also the documentation here:
Variable-length character string having maximum length size bytes or characters. Maximum size is 4000 bytes or characters, and minimum is 1 byte or 1 character. You must specify size for VARCHAR2.
https://docs.oracle.com/cd/B19306_01/server.102/b14195/sqlqr06.htm