如何实现文章表news，id字段值为5记录的点击数字段num自增（）。A、Update news set num=num+1；B、Update news set num=num+1 where id==5C、Update news set num=num++ where id=5D、Update news set num=num+1 where id=5

以下程序段的输出结果是。 num=0 while num<=2 num = num+1 wend Print

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);

将订单号为"0060"的订单金额改为169元，正确的SQL语句是A）UPDATE订单SET金额=169 WHERE订单号="0060"B）UPDATE订单SET金额WITH 169 WHERE订单号="0060"C）UPDATE FROM订单SET金额＝169 WHERE订单号="0060"D）UPDATE FROM订单SET金额WITH 169 WHERE订单号="0060"

使用如下数据表：仓库表(仓库号，所在城市) 职工表(职工号，仓库号，工资) 其中，仓库号、所在城市和职工号字段为字符型，工资字段为数值型。 将仓库号为A4的职工的工资改为2000．O0，正确的命令是（ ）。

A. UPDATE职工表SET工资WITH 2000．00 WHERE仓库号=”A4”

B. UPDATE职工表SET工资=2000．OO WHERE仓库号=”A4”

C. UPDATE FROM职工表SET工资wITH 2000．OO WHERE仓库号=”A4”

D. UPDATE FROM职工表SET工资=2000．OO WHERE仓库号=”A4”

在Visual FoxPro中，使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁，应该使用的命令是

A．REPLACE AGE WITH AGE+1

B．UPDATE STUDENT AGE WITH AGE+1

C．UPDATE SET AGE WITH AGE+I

D．UPDATE STUDENT SET AGE=AGE+1

给所有的选修课号为"0001"的女生的该课程成绩增加5分，使用的语句为_____

A UPDATE SKB SET 成绩 WITH 成绩+5 WHERE 课号 = “0001”AND 性别= “女”

B UPDATE SKB SET 成绩 = 成绩+5 WHERE 课号 = “0001”AND 性别 =“女”

C UPDATE SKB SET 成绩 = 成绩+5 WHERE 课号 = “0001”AND 学号 IN (SELECT * FROM STUDENT WHERE 性别 = “女”)

D UPDATE SKB SET 成绩 WITH 成绩+5 WHERE 课号 = “0001”AND 学号 IN (SELECT * FROM STUDENT WHERE 性别 = “女”)

在下列所给的操作中，哪个操作能被执行

A．UPDATE部门SET部门号=′05′WHERE部门名=′财务部′

B．UPDATE部门SET部门号=′05′WHERE部门名=′服务部′

C．UPDATE雇员SET工资=600 WHERE雇员号=′010′

D．UPDATE雇员SET部门号=′05′WHERE雇员号=′101′

对于学生信息表：student(sno，sname，sex，age，dept)，如果把学生“小明”的姓名改为“小强”，则正确的语句是（ ）。

A)UPDATE SET sname=‘小明’WHERE sname=‘小强’

B)UPDATE student SET sname=‘小明’WHERE sname=‘小强’

C)UPDATE student SET sname=‘小强’

D)UPDATE student SET sname=‘小强’WHERE sname=‘小明’

若要使所有学科80分以上的成绩都增加5%, 80至60分的成绩都增加10%，应如何更新数据库（ ）。 A．UPDATE SC SET GRADE=GRADE*1．05 WHERE SC．GRADE>=80 UPDATE SC SET GRADE=GRADE* 1．10 WHERE SC．GRADE>=60 AND SC．GRADE <=80 B．UPDATE SC SET GRADE=GRADE* 1．10 WHERE SC．GRADE>=60 AND SC．GRADE<=80 UPDATE SC SET GRADE=GRADE* 1．05 WHERE SC．GRADE>=80 C．UPDATE SC SET GRADE=GRADE* 1．05 WIRE SC．GRADE>=80 AND SET GRADE =GRADE* 1．10 WHARE SC．GRADE>=60 D．UPDATE SC SET GRADE=GRADE* 1．10 WHERE SC．GRADE>=60 AND SC．GRADE <=80 AND SET GRADE=GRADE* 1．05 WHERE SC．GRADE>=80

请填写以下Cisco 6500交换机端口配置命令的描述。

set port name mod_num／port_num[name_string] (1)

set port level mod—num／port_num noramal I high (2)

set port speed mod_num／port_num<1011001auto> (3)

set port duplex mod_num／port_num fullIhalf (4)

show port mod_num／port_num (5)