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

Examine the structure proposed for the TRANSACTIONS table:

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:

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.

Explanation:
B: The NUMBER datatype stores fixed and floating-point numbers. Numbers of virtually any
magnitude can be stored and are guaranteed portable among different systems operating Oracle,
up to 38 digits of precision.
The following numbers can be stored in a NUMBER column:

Positive numbers in the range 1 x 10-130 to 9.99…9 x 10125 with up to 38 significant digits
Negative numbers from -1 x 10-130 to 9.99…99 x 10125 with up to 38 significant digits
Zero
Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
D: The VARCHAR2 datatype stores variable-length character strings. When you create a table
with a VARCHAR2 column, you specify a maximum string length (in bytes or characters) between
1 and 4000 bytes for the VARCHAR2 column.
An interval literal specifies a period of time, and Oracle supports two types of interval literals:
YEAR_TO_MONTH and DAY TO SECOND. For DAY TO SECOND, you can specify these
differences in terms in terms of days, hours, minutes, and seconds. DAY TO SECOND contains a
leading field and may contain an optional trailing field. If trailing field is specified it must be less
significant than the leading field. For example, INTERVAL MINUTE TO DAY is not valid.
A DAY TO MINUTE interval considers an interval of days to the nearest minute.
Reference: Oracle Database Concepts 10g, Native Datatypes



Leave a Reply 10

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


freddy

freddy

b,c are more accurate
d? what kind of data to be restored?

Jason

Jason

i think TRANS_VALIDITY stored the seconds.when you want other type just like minutes ,hours you need a calculation .
and D if you do not specify the maximum value of the varchar2 it can store as max as it can .so it’s up to 4000

Jason

Jason

sorry ,i ‘m wrong .the type varchar2 must specify the maximum value .so it ‘s seem that D is wrong .

Bina

Bina

D is definitely wrong Varchar2 needs specify the a number, for char default value is 1. But there is no default value for varchar2

riccia

riccia

There is a mistake, the corect answers are: BC .Check 1Z0-051 QUEST 16.

xuzhiyuan

xuzhiyuan

I think it is BC

The VARCHAR2 data type must be qualified with a number indicating the maximum
length of the column.

ejossue

ejossue

You’re right!

xuzhiyuan

xuzhiyuan

The TRANS_VALIDITY is an INTERVAL DAY TO SECOND datatype. This will allow a
time span to be specified in days, hours, minutes, and seconds. The basic syntax for
an INTERVAL DAY TO SECOND column is
‘ ::’

Eamon

Eamon

Yes the correct answer is B and C, you are all right. Thanks guys!

Bogdan

Bogdan

B and C are accurate.
A is wrong. The format is DD-MON-YY
D is wrong VARCHAR2 make no sense without a number VARCHAR2(4000).

Regards,