以下是视图EMP_HIST_V的结构:
EMP_HIST_V
Name Type
------------------- ------------
EMPLOYEE_ID NUMBER(6)
NAME VARCHAR2(15)
JOB VARCHAR2(9)
MANAGER NUMBER(4)
DATE_HIRED DATE
SALARYNUMBER(7, 2)
BONUSNUMBER(7, 2)
DEPARTMENT_IDNUMBER(2)
在以下的SQL语句中,哪两个不能成功地查询视图EMP_HIST_V
A.SELECT *
FROM
emp_hist_v;
B.SELECT *
FROM VIEW emp_hist_v;
C.SELECT COUNT(*)
FROM
emp_hist_v;
D.SELECT COUNT(*)
FROM VIEW emp_hist_v;
E.SELECT COUNT (DISTINCT department_id)
FROM
emp_hist_v;