题目内容

ExaminethestructureoftheEMPLOYEEStable: ColumnnameDatatypeRemarks EMPLOYEE_IDNUMBERNOTNULL,PrimaryKey EMP_NAMEVARCHAR2(30) JOB_IDVARCHAR2(20)NOTNULL SALNUMBER MGR_IDNUMBERReferencesEMPLOYEE_IDcolumn DEPARTMENT_IDNUMBERForeignkeytoDEPARTMENT_IDcolumn oftheDEPARTMENTStable YouneedtocreateaviewcalledEMP_VUthatallowstheuserstoinsertrowsthroughtheview.WhichSQLstatement,whenusedtocreatetheEMP_VUview,allowstheuserstoinsertrows?（）

A. CREATEVIEWemp_vuASSELECTemployee_id,emp_name,department_idFROMemployeesWHEREmgr_idIN(102,120);
B. CREATEVIEWemp_vuASSELECTemployee_id,emp_name,job_id,department_idFROMemployeesWHEREmgr_idIN(102,120);
CREATEVIEWemp_vuASSELECTdepartment_id,SUM(sal)TOTALSALFROMemployeesWHEREmgr_idIN(102,120)GROUPBYdepartment_id;
D. CREATEVIEWemp_vuASSELECTemployee_id,emp_name,job_id,DISTINCTdepartment_idFROMemployees;

查看答案

搜索结果不匹配？点我反馈

更多问题

A. 油底壳
B. 滤清器
C. 主油道
D. 机油泵上

A. Compilation fails.
B. atom granite
C. granite granite
D. atom granite granite
E. An exception is thrown at runtime.
F. atom granite atom granite

A
B
C
D

A. 活动管理
B. 电话营销
C. 电子营销
D. 潜在客户管理