网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
下列哪个语句查出雇员表(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’
考题
以下说法错误的是( )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;
考题
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;
考题
与“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
考题
列出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;
考题
（ 30 ）与 “ 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
考题
下列哪个语句查出雇员表（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’
考题
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.
考题
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
考题
下面哪条语句可以取出薪水最高的前三个人：（）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；
考题
下列SQL语句中，能够完成并运算的是（）。A、SELECT * FROM 篮球爱好者 UNION SELECT * FROM 足球爱好者B、SELECT * FROM 篮球爱好者 INTERSECT SELECT * FROM 足球爱好者C、SELECT * FROM 篮球爱好者 EXCEPT SELECT * FROM 足球爱好者D、SELECT * FROM 篮球爱好者 ，足球爱好者
考题
下列命令不能执行的是（）。A、SELECT * FROM [select]B、SELECT * FROM @MyTableC、SELECT * FROM [MyTable]D、SELECT * FROM MyTable
考题
设有一自由表xx.dbf，下列SELECT-SQL命令中语法错误的是（）A、SELECT * FROM xxB、SELECT * FROM xx INTO CURSOR tempC、SELECT * FROM xx INTO TABLE tempD、SELECT * FROM xx INTO temp
考题
数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）A、Select * From EmpB、Select * From Emp Where EmpNO Like '%%'C、Select * From Emp Where Name = '%%'D、Select * From Emp Where Name Like '%%'
考题
数据库中有一张表名为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!=’办事员’
考题
数据库中有一张表名为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'
考题
在Transact-SQL语法中，以下SELECT语句正确的是（）。A、SELECT * FROM studentB、SELECT * FROM student WHERE GETDATE（）C、SELECT * FROM student ORDER st_idD、SELECT * FROM student BY St_name
考题
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.
考题
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_';
考题
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));
考题
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;
考题
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) 20000E、None of the statements produce an error; all are valid.
考题
假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下（）方式。A、SELECT name，status FROM V$datafileB、SELECT name，statusFROM V$userfileC、SELECT name，status FROM V$DBAD、SELECT name，status FROM V$ctrlfile
考题
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;
考题
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;
考题
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) 20000E、None of the statements produce an error; all are valid.
考题
列出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;
考题
单选题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
热门标签
最新试卷
