133. 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 bi nary data in anoperating
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
Answer: ADE
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 bi nary data in anoperating
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
Answer: ADE
SQL>create table huang(id varchar2(1))
Table created.
说明D选项是对的
SQL> create table huang(id char(10));
Table created.
SQL> create table huang(id char(10));
Table created.
SQL> insert into huang values('H');
1 row created.
SQL> select COLUMN_NAME,DATA_TYPE ,DATA_LENGTH from dba_tab_columns where table_name='HUANG';
COLUMN_NAME
------------------------------------------------------------
DATA_TYPE
--------------------------------------------------------------------------------
DATA_LENGTH
-----------
ID
CHAR
10
SQL> select * from huang;
ID
--------------------
H
说明E选项是对的
</pre><pre name="code" class="html">