24. 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.
Answer: BC
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.
SQL> drop table TRANSACTIONS purge;
Table dropped
SQL> create table TRANSACTIONS
2 (
3 CUST_STATUS VARCHAR2 NOT NULL
4 );
create table TRANSACTIONS
(
CUST_STATUS VARCHAR2 NOT NULL
)
ORA-00906: 缺失左括号
SQL> create table TRANSACTIONS
2 (
3 TRANS_ID NUMBER(6) NOT NULL,
4 CUST_NAME VARCHAR2(20) NOT NULL,
5 TRANS_DATE DATE NOT NULL,
6 TRANS_VALIDITY INTERVAL DAY TO SECOND,
7 CUST_CREDIT_VALUE NUMBER(10)
8 );
Table created
D不对
SQL> insert into TRANSACTIONS(TRANS_ID,CUST_NAME,TRANS_DATE,TRANS_VALIDITY,CUST_CREDIT_VALUE) values(1,'a',sysdate,INTERVAL '12 13:14:15' DAY TO SECOND,1.2);
1 row inserted
SQL> insert into TRANSACTIONS(TRANS_ID,CUST_NAME,TRANS_DATE,TRANS_VALIDITY,CUST_CREDIT_VALUE) values(1,'a',sysdate,INTERVAL '12 13:14:15' DAY TO SECOND,-1.2);
1 row inserted
SQL> col cust_name form a10
SQL> col TRANS_VALIDITY form a30
SQL> select * from TRANSACTIONS;
TRANS_ID CUST_NAME TRANS_DATE TRANS_VALIDITY CUST_CREDIT_VALUE
-------- ---------- -------------------- ------------------------------ -----------------
1 a 2014-5-15 17:45:50 +12 13:14:15.000000 1
1 a 2014-5-15 17:46:01 +12 13:14:15.000000 -1
2 rows selected
a不对,b与c对
Answer: BC