以下能删除表的语句是( ) A: Delete * from emp B: Drop database emp C: Drop * from emp D: delete database emp

EMP途径

分析下面的JavaScript代码段，输出的结果是()。 var emp=new Array(5); emp[1]=1; emp[5]=2; document.write(emp.length);

查询员工表emp中的第3条到第8条记录。显示emp表中的全部字段。( ) A: select rownum rn,emp.* from emp where rownum3; B: select * from(select rownum RN,emp.* from emp where RN3; C: select * from(select rownum RN,emp.* from emp where rownum3; D: select rownum RN,emp.* from emp where RN3;

下面删除记录的语句正确的是( ) A: delete from emp where name="Tony"; B: delete * from emp where name="Tony"; C: drop from emp where name="Tony"; D: drop * from emp where name="Tony";

名词解释： EMP途径：

以下语句错误的是( ) A: alter table emp delete column addcolumn; B: alter table emp modify column addcolumn char(10); C: alter table emp change addcolumn addcolumn int; D: alter table emp add column addcolumn int;

设有职工基本表：EMP(ENO，ENAME，AGE，SEX，SALARY)，其属性分别表示职工号、姓名、年龄、性别、工资。为每个工资低于平均工资的女职工加薪200元，以下SQL语句正确的是______。 A: UPDATE EMP SET SALARY=SALARY+200 B: WHERE SALAEY＜(SELECT AVG(SALARY)FROM EMP) AND SEX=’女’ C: UPDATE FROM EMP SET SALARY=200 D: WHERE SALAEY＜(SELECT SUM(SALARY)FROM EMP)AND SEX=’女’ E: UPDATE EMP SET SALARY=200 F: WHERE SALAEY＜(SELECT AVG(SALARY)FROM EMP)AND SEX=’女’ G: UPDATE FROM EMP SET SALARY=SALARY+200 H: WHERE SALAEY＜(SELECT SUM(SALARY)FROM EMP)AND SEX=’女’

以下语句不正确的是( ) A: select * from emp; B: select ename,hiredate,sal from emp; C: select * from emp order deptno; D: select * from where deptno=1

统计每个部门中人数的语句是？ A: select count(id) from emp order by deptno; B: select sum(id) from emp order by deptno; C: select count(id) from emp group by deptno; D: select sum(id) from emp group by deptno;