一、原题
答案:BC
二、题目翻译
三、题目解析
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.
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.
答案:BC
二、题目翻译
查看下面TRANSACTIONS表的结构:
关于该表结构的数据存储哪两句话是正确的?(选择两个)
A. TRANS_DATE列只能存储dd-mon-yyyy格式的数据。
B. CUST_CREDIT_VALUE列可以存储正整数与负整数。
C. TRANS_VALIDITY列可以存储从days, hours, minutes, 到seconds的一段时间区间。
D. CUST_STATUS列存储的数据可以达到VARCHAR2的最大值4000个字符。
关于该表结构的数据存储哪两句话是正确的?(选择两个)
A. TRANS_DATE列只能存储dd-mon-yyyy格式的数据。
B. CUST_CREDIT_VALUE列可以存储正整数与负整数。
C. TRANS_VALIDITY列可以存储从days, hours, minutes, 到seconds的一段时间区间。
D. CUST_STATUS列存储的数据可以达到VARCHAR2的最大值4000个字符。
三、题目解析
A选项不正确,因为DATE不仅仅只能存储该dd-mon-yyyy格式的日期数据,还可以存其它格式,比如:yyyy-mm-dd这样的格式,还可以带有时分秒的
D选项不正确,因为VARCHAR2不能省略size,所以会报错,需要加上长度,比如: VARCHAR2(10)
D选项不正确,因为VARCHAR2不能省略size,所以会报错,需要加上长度,比如: VARCHAR2(10)