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

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

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.



Leave a Reply 9

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


Mosa

Mosa

Why is A incorrect?

rca ieftin online

rca ieftin online

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

Rene Ensminger

Rene Ensminger

Thanks again for the article.Much thanks again. Cool.

Ade

Ade

i think C is wrong and the correct answer should be B and D

Iliana Zagorski

Iliana Zagorski

Thank you ever so for you blog post.Really thank you! Want more.