单选题How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console？（）Aselect Kill from the menuBselect Release from the menuCselect Cancel Job from the menuDselect Cancel Pending from the menu

题目
单选题
How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console？（）
A

 select Kill from the menu

B

 select Release from the menu

C

 select Cancel Job from the menu

D

 select Cancel Pending from the menu

相似考题

1.下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。A.select employeesno，ename Name，job from employees where ename=‘SMITH’B.select employeesno，ename ‘Name’，job from employees where ename=SMITHC.select employeesno，ename “Name”，job from employees where ename=‘SMITH’D.select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’

2.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;

3.与“SELECT*FROM教师表INTO DBF A”等价的语句是A．SELECT*FROM教师表TO DBF AB．SELECT*FROM教师表TO TABLE AC．SELECT*FROM教师表INTO TABLE AD．SELECT*FROM教师表INTO A

4.以下说法错误的是( )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;

更多“单选题How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console？（）A  select Kill from the menuB  select Release from the menuC  select Cancel Job from the menuD  select Cancel Pending from the menu”相关问题

  • 第1题：

    列出EMP表中,从事每个工种(JOB)的员工人数()

    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;


    参考答案：D

  • 第2题：

    下列哪个语句查出雇员表（employees）里的雇员名字（ename）是‘SMITH’的信息，并且给雇员名字（ename）列定义一个别名Name（）。

    • 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’

    正确答案:A

  • 第3题：

    How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console？（）

    • A、 select Kill from the menu
    • B、 select Release from the menu
    • C、 select Cancel Job from the menu
    • D、 select Cancel Pending from the menu

    正确答案:A

  • 第4题：

    下列SQL语句中，能够完成并运算的是（）。

    • A、SELECT * FROM 篮球爱好者  UNION  SELECT * FROM 足球爱好者
    • B、SELECT * FROM 篮球爱好者  INTERSECT  SELECT * FROM 足球爱好者
    • C、SELECT * FROM 篮球爱好者  EXCEPT  SELECT * FROM 足球爱好者
    • D、SELECT * FROM 篮球爱好者 ，足球爱好者

    正确答案:A

  • 第5题：

    设有一自由表xx.dbf，下列SELECT-SQL命令中语法错误的是（）

    • A、SELECT * FROM xx
    • B、SELECT * FROM xx INTO CURSOR temp
    • C、SELECT * FROM xx INTO TABLE temp
    • D、SELECT * FROM xx INTO temp

    正确答案:D

  • 第6题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。查询出职位不为“办事员”的雇员信息是（）

    • A、Select *From Emp Where Job>="办事员"
    • B、Select* From Emp Where Job==’办事员’
    • C、Select* From Emp Where Job<>’办事员’
    • D、Select* From Emp Where Job!=’办事员’

    正确答案:C,D

  • 第7题：

    在Transact-SQL语法中，以下SELECT语句正确的是（）。

    • A、SELECT * FROM student
    • B、SELECT * FROM student WHERE GETDATE（）
    • C、SELECT * FROM student ORDER st_id
    • D、SELECT * FROM student BY St_name

    正确答案:A

  • 第8题：

    The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

    • A、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
    • B、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
    • C、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "/";
    • D、SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

    正确答案:A

  • 第9题：

    Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_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;

    正确答案:B

  • 第10题：

    假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下（）方式。

    • A、SELECT name，status FROM V$datafile
    • B、SELECT name，status FROM V$userfile
    • C、SELECT name，status FROM V$DBA
    • D、SELECT name，status FROM V$ctrlfile

    正确答案:A

  • 第11题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

    • A、LOCK TABLE emp IN SHARE MODE;
    • B、LOCK TABLE emp IN EXCLUSIVE MODE;
    • C、DELETE FROM emp WHERE job=’MANAGER’;
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
    • E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

    正确答案:A,B,E

  • 第12题：

    列出EMP表中，从事每个工种（JOB）的员工人数（）

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

    正确答案:D

  • 第13题：

    （ 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


    正确答案：C

  • 第14题：

    How do you start an event-triggered debug session?（）

    • A、Select "Start" from the Debug menu in CRS Script Editor.  
    • B、Select "Reactive Script..." from the Debug menu in CRS Script Editor.  
    • C、Select "Debugging" from the Trace menu in CRS Application Administration.  
    • D、Select "Start Trace" from the Trace menu in CRS Application Administration.

    正确答案:B

  • 第15题：

    下面哪条语句可以取出薪水最高的前三个人：（）

    • A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；
    • B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；
    • C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；
    • D、SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；

    正确答案:C

  • 第16题：

    下列命令不能执行的是（）。

    • A、SELECT * FROM [select]
    • B、SELECT * FROM @MyTable
    • C、SELECT * FROM [MyTable]
    • D、SELECT * FROM MyTable

    正确答案:B

  • 第17题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）

    • A、Select * From Emp 
    • B、Select * From Emp Where EmpNO Like '%%' 
    • C、Select * From Emp Where Name = '%%' 
    • D、Select * From Emp Where Name Like '%%'

    正确答案:A,B,D

  • 第18题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float），Comm（奖金，Float，可为空）。查询出雇员编号为791，792，793的雇员信息是（）

    • A、Select * From Emp Where EmpNO  In('791','792','793') 
    • B、Select * From Emp Where EmpNO ='791' Or EmpNO='792' OR EmpNO='793' 
    • C、Select * From Emp Where EmpNO >='791' And EmpNO<='793' 
    • D、Select * From Emp Where EmpNO >'791' And EmpNO<'793'

    正确答案:A,B,C

  • 第19题：

    Using the Tivoli Dynamic Workload Console， what are two ways to  change the priority of a job？（）

    • A、 Open the "Set Priority" panel from the job properties.
    • B、 Change the priority of the job stream that contains the job.
    • C、 Select the corresponding action from the Monitor jobs task panel.
    • D、 Open the job stream properties and drill down to the job priority  panel.
    • E、 The priority of a job can only be changed from the Workload  Designer.

    正确答案:A,C

  • 第20题：

    Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）

    • A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
    • B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
    • C、SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
    • D、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
    • E、SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
    • F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

    正确答案:C,D,E

  • 第21题：

    Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

    • A、SELECT * FROM emp_dept_vu;
    • B、SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
    • C、SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
    • D、SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
    • E、None of the statements produce an error; all are valid.

    正确答案:E

  • 第22题：

    Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）

    • A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;
    • B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
    • C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
    • D、SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
    • E、SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

    正确答案:E

  • 第23题：

    Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

    • A、SELECT * FROM emp_dept_vu;
    • B、SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
    • C、SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
    • D、SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
    • E、None of the statements produce an error; all are valid.

    正确答案:E

  • 第24题：

    单选题
    How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console？（）
    A

     select Kill from the menu

    B

     select Release from the menu

    C

     select Cancel Job from the menu

    D

     select Cancel Pending from the menu


    正确答案： D
    解析： 暂无解析

相关内容