移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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?()

发布日期:2022-07-12

Examine the structure of the EMP_DEPT_VU view: Col...
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

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!