select Kill from the menu
select Release from the menu
select Cancel Job from the menu
select Cancel Pending from the menu
第1题：
Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)JOB_CAT VARCHARD2(30)SALARY NUMBER(8,2)Which statement shows the maximum salary paid in each job category of each department? （）
A. SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);
B. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;
C. SELECT dept_id, job_cat, MAX(salary) FROM employees;
D. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
E. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;
第2题：
A.select job from emp;
B.select job,count(*) from emp;
C.select distinct job,count(*) from emp;
D.select job,count(*) from emp group by job;
E.select job,sum(empno) from emp group by job;
第3题：
A.select employeesno，ename Name，job from employees where ename=‘SMITH’
B.select employeesno，ename ‘Name’，job from employees where ename=SMITH
C.select employeesno，ename “Name”，job from employees where ename=‘SMITH’
D.select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’
第4题：
How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console？（）
第5题：
下列哪个语句查出雇员表（employees）里的雇员名字（ename）是‘SMITH’的信息，并且给雇员名字（ename）列定义一个别名Name（）。
第6题：
与“SELECT*FROM教师表INTO DBF A”等价的语句是
A．SELECT*FROM教师表TO DBF A
B．SELECT*FROM教师表TO TABLE A
C．SELECT*FROM教师表INTO TABLE A
D．SELECT*FROM教师表INTO A
第7题：
（ 30 ）与 “ SELECT * FROM 教师表 INTO DBF A ” 等价的语句是
A ） SELECT * FROM 教师表 TO DBF A
B ） SELECT * FROM 教师表 TO TABLE A
C ） SELECT * FROM 教师表 INTO TABLE A
D ） SELECT * FROM 教师表 INTO A
第8题：
以下说法错误的是( )
A.SELECT max(sal),deptno,job FROM EMP group by sal;
B.SELECT max(sal),deptno,job FROM EMP group by deptno;
C.SELECT max(sal),deptno,job FROM EMP;
D.SELECT max(sal),deptno,job FROM EMP group by job;
第9题：
How do you start an event-triggered debug session?（）
第10题：
下面哪条语句可以取出薪水最高的前三个人：（）