【071考试题库】OCP-1Z0-071最新考试题库大全-第2题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍071的题库。
每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验证ocp
-------------------------------------------------------
071考试题库2、choose two
Examine the description of the EMP_DETAILS table given below:
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?
A) You cannot add a new column to the table with LONG as the data type.
B) An EMP_IMAGE column can be included in the GROUP BY clause.
C) You can alter the table to include the NOT Nun., constraint on the EMP_IMAGE column.
D) An EMP_IMAGE column cannot be included in the ORDER BY clause.
Answer:AD
(解析：
答案 A：
SQL> alter table sales add emp_info long;
alter table sales add emp_info long *
第 1 行出现错误:
ORA-01754: 表只能包含一个 LONG 类型的列。
答案 D：
SQL> select * from sales
2 order by emp_image;
select * from sales
*
第 1 行出现错误:
ORA-00997: 非法使用 LONG 数据类型
)
精华阅读