Examine the structure if the EMPLOYEES table:Column name Data Type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）A. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);B. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);C. CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;D. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

Examine the structure if the EMPLOYEES table:Column name Data Type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）

A. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);

B. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);

C. CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;

D. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

相关考题：

清使用VC6或使用【答题】菜单打开考生文件夹projl下的工程projl，此工程中包含了类Pets(“宠物”) 和主函数main的定义。程序中位于每个“//ERROR****found ****”之后的一行语句有错误，请加以改 正。改正后程序的输出结果应为： Name：sonny Type：dog Name：John Type：dog Name：Danny Typc：cat Name：John Type：dog 注意：只修改每个“//ERROR ****found ****”下的那一行，不要改动程序中的其他内容。 includeiostream using namespace sm； enum Pets_type{d09，cat，bird，fish}； class Pets{ private： char *name； Pets_type type； public： Pets(const char *name=”sonny”，Pets_type type=dog)； Petsoperator=(const Petss)； ～Pets； void showeonst；}； Pets：：Pets(eonst char$naIne，Pets_type type) //构造函数 { This -name=new char[strlen(name)+1]； strcpy(this一name，name)； //ERROR *********found********* type=type； }{ Pets：：～Pets//析构函数，释放name所指向的字符串 { //ERROR *********found********* name=’/0‘； } PetsPets：：0perator=(const Petss){ if(s==this)//确保不要向自身赋值 return *this； delete[]name； name=new char[strlen(S．name)+1]；//ERROR *********found********* strcpy(this一nmne，name)； type=S．type： return *this；} void Pets：：showconst cout“Name：”name”Type：”： Pets mypetl，mypet2(’’John”，dog)；
查看答案
Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?（）A.B.C.D.E.
查看答案
物化视图日志默认的名字是:() A. M$LOG_TABLE_NAMEB. MLOG$_TABLE_NAMEC. MLOG_ TABLE_NAME
查看答案
有Table1,Table2两表,Table2是Table1的从表,Table1表有字段head_id(主键)和head_name,Table2表有字段Line_id(主键),head_id(外键),line_name,现要求查询统计出有那些hand_name在Table2表中有2条以上的数据。请写出你的SQL语句。
查看答案
函数substr(“DATASTRUCTURE”，5，9)的返回值为()。A.“STRUCTURE”B.“DATA”C.“DATASTRUCTURE”D.“ASTRUCTUR”
查看答案
Most operating systems have a standard set of ( ) to handle the processing of all input and output instructions. A.spreadsheet B.control instructions C. I/O operation D.datA.table
查看答案
如果table_name表中有索引index_name，删除此索引的语句错误的是（）。A．DROP INDEX index_name ON talbe_nameB．ALTER TABLE table_name DROP INDEX index_nameC．DROP INDEX table_name.index_nameD．ALTER TABLE table_name DROP CONSTRAINT index_name
查看答案
下列定义函数的方法，在Python中正确的是（）。A．class＜name＞(＜type＞ arg1,＜type＞ arg2,…＜type＞argN)B．function ＜name＞(arg1,arg2,…argN)C．def ＜name＞(arg1,arg2,…argN)D．def ＜name＞(＜type＞ arg1,＜type＞ arg2,…＜type＞argN)
查看答案
Python 如何定义一个函数（)A．class ＜name＞(＜type＞ arg 1,＜ type＞ arg2, … ＜type＞ argN)B．function ＜name＞(arg 1,arg 2, … argN)C．def ＜name＞(arg 1,arg 2, … argN)D．def ＜name＞(＜type＞ arg 1,＜ type＞ arg2, … ＜type＞ argN)
查看答案
2、下列定义函数的方法，在Python中正确的是（）。A．class＜name＞(＜type＞ arg1,＜type＞ arg2,…＜type＞argN)B．function ＜name＞(arg1,arg2,…argN)C．def ＜name＞(arg1,arg2,…argN)D．def ＜name＞(＜type＞ arg1,＜type＞ arg2,…＜type＞argN)
查看答案
热门标签