24.Examine the structure proposed for the TRANSACTIONS table:
来源:互联网 发布:matlab怎么编程 编辑:程序博客网 时间:2024/05/16 16:11
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.
答案:BC
解析:
A:错误,TRANS_DATE可以存储其他格式,只要修改默认的类型nls_data_format就可以了
B:正确,可以存储正数和负数
C:正确,
D:错误,这里varchar2可以在sql中存储的是4000个bytes,而不是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
解析:
A:错误,TRANS_DATE可以存储其他格式,只要修改默认的类型nls_data_format就可以了
B:正确,可以存储正数和负数
C:正确,
D:错误,这里varchar2可以在sql中存储的是4000个bytes,而不是characters,
0 0
- 24.Examine the structure proposed for the TRANSACTIONS table:
- 23.Examine the structure proposed for the TRANSACTIONS table:
- 102.Examine the structure of the TRANSACTIONS table:
- 103.Examine the structure of the TRANSACTIONS table:
- 90.Examine the structure and data in the PRICE_LIST table:
- 94.Examine the structure of the PROGRAMS table:
- 6.Examine the structure of the SHIPMENTS table:
- 18.Examine the structure of the PROMOTIONS table:
- 86.Examine the structure and data of the CUST_TRANS table:
- 96.Examine the structure of the INVOICE table.
- 104.Examine the structure of the PROMOS table:
- 105.Examine the structure of the PROMOS table:
- 109.Examine the structure of the MARKS table:
- 113.Examine the structure of the ORDERS table:
- 125.Examine the structure of the CUSTOMERS table:
- 140.Examine the structure of the PRODUCTS table:
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 10.View the Exhibit;examine the structure of the PROMOTIONS table.
- 用80x86汇编语言编程--统计输入的字符个数
- 用80x86汇编语言编程--过滤数字符号,并且大小写转换
- 顺序输出片内RAM的数据
- 《血色浪漫》中秦岭的陕北民歌
- host命令
- 24.Examine the structure proposed for the TRANSACTIONS table:
- [问题记录] openssl error:0906D064:PEM routines:PEM_read_bio:bad base64 decode
- 等待春天
- 51单片机 汇编语言 两道题
- SSH端口转发
- 80x86汇编:将AL中的8位无符号数转换为压缩型BCD数放入AX
- 【Modern OpenGL】光照类型 Light casters
- 中值滤波
- tomcat 加 gzip 压缩