OCP-1Z0-051-Question Analysis-23rd question

23. 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 CHAR
TRANS_DATE NOT NULL DATE
TRANS_VALIDITY VARCHAR2
CUST_CREDIT_LIMIT NUMBER
Which statements are true regarding the creation and storage of data in the above table structure?
(Choose all that apply .)
A. The CUST_STATUS column wowould give an error.
B. The TRANS_VALIDITY column wowould give an error.
C. The CUST_STATUS column wocould store exactly one character.
D. The CUST_CREDIT_LIMIT column wocould not be able to store decimal values.
E. The TRANS_VALIDITY column wowould have a maximum size of one character.
F. The TRANS_DATE column wocould be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.




Answer: BC


1) VARCHAR2 variable character data type (MaxSize = 4000, MinSize = 1, MaxSize must be specified)
2) CHAR character data type with fixed length (MaxSize = 2000, MinSize = 1, not specified as 1 by default)
3) NUMBER Syntax: NUMBER (p, s ):
P: precision, which is the total number of valid data digits. The value range is 38. The default value is 38. The character * can be used to represent 38.
S: decimal place, scale, which is the right digit of the decimal point. The value range is-84 ~ 127. The default value depends on p. If p is not specified, s is the maximum range. If p is specified, s = 0.
4) DATE: only accurate to seconds.


A: The CUST_STATUS field is incorrect. (Error, see 1 above)
B: The TRANS_VALIDITY field is incorrect. (Correct, see 2)
C: CUST_STATUS stores a character correctly. (Correct, see 2)
D: The CUST_CREDIT_LIMIT field cannot store decimals. (Error, see 3)
E: the maximum value of the TRANS_VALIDITY field is one character. (Error, see 1)
F: The TRANS_DATE field can store the seconds of the day, month, Century, year, hour, minute, second, and decimal part. (Error, see 4)