Examine the structure proposed for the TRANSACTIONS table:
name Null Type
TRANS_ID NOT NULL NUMBER(6)
CUST_NAME NOT NULL VARCHAR2(20)
CUST_STATUS NOT NULL VARCHAR2
TRANS_DATE NOT NULL DATE
TRANS_VALIDITY INTERVAL DAY TO SECOND
CUST_CREDIT_VALUE NUMBER(10)
Which two statements are true regarding the storage of data in the above table structure? (Choose two.)
A.
The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.
B.
The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
C.
The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.
D.
The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.
I got it right, but don’t know why B is correct. Thanks.
You can see here why B is correct: http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT313
Why is A incorrect?
REASON WHY A IS WRONG
http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT413
For input and output of dates, the standard Oracle date format is DD-MON-YY, as follows: ’13-NOV-92′
Hiya, I’m really glad I discovered this info. Today bloggers publish nearly gossips and net which is actually frustrating. A good website with exciting content, and this I need. Thanks for keeping this great site, I’ll be visiting it. Do you do newsletters? Can’t believe it is.
rca ieftin online http://goo.gl/6GqA7S
puedo estar de acuerdo concurren con el escribir-up
http://www.opinionesdating.com/meetic-opiniones/
Thanks again for the article.Much thanks again. Cool.
i think C is wrong and the correct answer should be B and D
Thank you ever so for you blog post.Really thank you! Want more.