OCP 1Z0 051 20

20. Which  three  statements  are  true  regarding  the  data  types  in Oracle Database  10g/11g?  (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 width. 

A.

SQL> create table t1 (l1 long);
Table created

SQL> alter table t1 add (l2 long);
alter table t1 add (l2 long)
ORA-01754: 表只能包含一个 LONG 类型的列

B.

SQL> drop table t1 purge;
Table dropped

SQL> create table t1 (tm timestamp);
Table created

SQL> insert into t1 values(systimestamp);
1 row inserted

SQL> select * from t1;
TM
--------------------------------------------------------------------------------
15-5月 -14 11.33.40.250000 上午
1 row selected

C.

SQL> drop table t1 purge;
Table dropped


SQL> create table t1 (bb blob,cb clob);
Table created


SQL> insert into t1 values('aa','aa');
1 row inserted

SQL> select * from t1;
BB CB
-- -----
<B aa
1 row selected

D.

SQL> drop table t1 purge;
Table dropped

SQL> create table t1 (vc varchar2(1));
Table created

E.

SQL> drop table t1 purge;
Table dropped

SQL> create table t1 (c char(5));
Table created
Executed in 0.031 seconds

SQL> insert into t1 values('a');
1 row inserted
Executed in 0.016 seconds

SQL> select '*' || c || '%' from t1;
'*'||C||'%'
-----------
*a    %
1 row selected

Answer: ADE