Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) DEFAULT ‘SA_REP‘SAL NUMBERCOMM_PCT NUMBERMGR_ID NUMBERDEPARTMENT_ID NUMBERYou need to update the records of employees 103 and 115. The UPDATE

题目

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) DEFAULT ‘SA_REP‘SAL NUMBERCOMM_PCT NUMBERMGR_ID NUMBERDEPARTMENT_ID NUMBERYou need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:JOB_ID: Default value specified for this column definition.SAL: Maximum salary earned for the job ID SA_REP.COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable.Which UPDATE statement meets the requirements?（）

A. UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = ‘SA_REP‘) AND comm_pct = DEFAULT AND department_id = &did WHERE employee _id IN (103,115);

B. UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job _ id = ‘SA_ REP‘;

C. UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = ‘SA_REP‘), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);

D. UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job _ id = ‘SA_ REP‘;

E. UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = ‘SA_REP‘) comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);

相似考题

1.We will do our best to ( ) shipment to meet your requirements in time.A.expectB.expediteC.exerciseD.examine

2.After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.

3.检查A.expectB.exceptC.excuseD.examine

4.I think the door is locked. But I'll go and ().A、checkB、examine

参考答案和解析
参考答案：C
更多“Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2( ”相关问题

  • 第1题：

    varchar2,char两种数据类型有什么区别,如果库表某字段输入"ABC"后储存,该 字段数

    据类型分别为varchar2(10,char(10)存储字节长度以及内容有何区别?


    正确答案：
     

  • 第2题：

    Nothing in these Rules shall ______ any vessel，or the owner，master or crew thereof，from the consequences of any precaution which may be required by the ordinary practice of seaman，or by the special circumstances of the case．

    A.exonerate

    B.exhaust

    C.exercise

    D.examine


    正确答案：A

  • 第3题：

    如果Number=3，请指出下列语句的真与假。 If Number = 3, point out the truth and false of the following statements. Int（Number * Number) = Number * Number


    错误

  • 第4题：

    找出"作者"库表中没有出现在"获奖名单"库表中的所有作者信息的SQL语句,(提示:使用

    NOT IN,NOT EXISTS,以及外部连接(+)三种方法),并说明那种方法是不优化的

    出版社: 出版社代码 char(2),出版社名称 varchar2(32)

    图书: 图书编号 char(8),图书名称 varchar2(128),出版社代码 char(2),作者代号

    char(4),图书简介 varchar2(128)

    作者: 作者代号 char(4),作者名称 varchar2(10),性别 char(1),年龄 number(3),文学

    方向 varchar2(64)

    获奖名单: 获奖日期 date,获奖人员 char(4)


    正确答案：
     

  • 第5题：

    He rolled up his trouer leg to exhibit his wounded knee.

    A:spread
    B:open
    C:show
    D:examine

    答案：C
    解析：
    本句意思：他卷起他的裤腿来显露受伤的膝盖。exhibit展示，显示。spread伸开，展开；open打开；show展示，出示；examine检查。

  • 第6题：

    24、如果Number=7，下列命题为真。 If Number = 7, point out the truth or false of the following expressions. Sqrt（Number*Number ) == Int（Sqrt（Number*Number))


    错误

相关内容