21. Examine the description of the EMP_DETAILS table given below:
name NULL TYPE
EMP_ID NOT NULL NUMBER
EMP_NAME NOT NULL VARCHAR2 (40)
EMP_IMAGE LONG
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL
table? (Choose two.)
A. An EMP_IMAGE column can be included in the GROUP BY clause.
B. An EMP_IMAGE column cannot be included in the ORDER BY clause.
C. You cannot add a new column to the table with LONG as the data type.
D. You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column.
为什么C是对的，C不是就是不能在一个表中加一个long字段的新列吗？
我试了貌似可以呢？？？
------解决方案--------------------
hr@ORCL> create table emp_details (emp_id number not null,emp_name varchar2(40) not null,emp_image long);
Table created.
hr@ORCL> alter table emp_details add (test_c long);
alter table emp_details add (test_c long)
*
ERROR at line 1:
ORA-01754: a table may contain only one column of type LONG