试题详情
- 单项选择题 Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）
A、SELECT*FROMemp_dept_vu；
B、SELECTdepartment_id，SUM（salary）FROMemp_dept_vuGROUPBYdepartment_id；
C、SELECTdepartment_id，job_id，AVG（salary）FROMemp_dept_vuGROUPBYdepartment_id，job_id；
D、SELECTjob_id，SUM（salary）FROMemp_dept_vuWHEREdepartment_idIN（10，20）GROUPBYjob_idHAVINGSUM（salary）>；20000；
E、Noneofthestatementsproduceanerror；allarevalid
关注下方微信公众号，在线模考后查看
热门试题
- Which object privile
- EvaluatethesetwoSQLs
- The STUDENT_GRADES
- The EMP table has t
- The database admini
- Which three are true
- Which three statemen
- Evaluate the SQL st
- TheEMPtablehasthesec
- EvaluatethisSQLstate
- Examine the structu
- What is necessary fo
- In which case would
- ExaminethedataintheE
- Examine the structu
- The PRODUCTS table
- Examine the structu
- Which three are DATE
- The CUSTOMERS table
- Which substitution v