QUESTION 132 Only one LONG column can be used per table

QUESTION 132
Which three statements are true? (Choose three.)
A. Only one LONG column can be used per table.
B. A TIMESTAMP data type column stores only time values with fractional seconds.
C. The BLOB data type column is used to store binary data in an operating system file.
D. The minimum column width that can be specified for a varchar2 data type column is one.
E. The value for a CHAR data type column is blank-padded to the maximum defined column Certkey.com -
Make You Succeed To Pass IT Exams
Certkey 650-026
width.
Answer: ADE
Section: (none)

解析：

A. 每个表中只能使用一个LONG列。正确

B. 一个TIMESTAMP数据类型列只能存储带有小数秒的时间值。错误，也可以存储不带小数秒的日期或时间

C. BLOB数据类型列被用于存储二进制数据的操作系统文件。错误，不是操作系统文件。

D. 对于VARCHAR2数据类型最小的列宽可以为1（VARCHAR2为可变长度的数据类型）.

E. CHAR数据类型列的值是用空格填充到列定义的最大值（也就是说，如果定义了CHAR(20),而字符串长度不够20个，则用空格填充不够的位数，CHAR为固定长度数据类型）