下列（）命令在记录上设置了一个或多个排他锁。A、ALTERTABLEEMPADDCOLUMNBIRTHDAY（DATE）；B、UPDATEEMPSETSAL=SAL*1.5+100；C、UPDATEEMPSETSAL=SAL*1.1WHEREEMPNO=OOO01；D、SELECT*FROMEMP；E、DROPTABLEEMP；F、CREATEINDEXENAME_IDXONEMP（ENAME）；
下列（）命令在记录上设置了一个或多个排他锁。
- A、ALTERTABLEEMPADDCOLUMNBIRTHDAY（DATE）；
- B、UPDATEEMPSETSAL=SAL*1.5+100；
- C、UPDATEEMPSETSAL=SAL*1.1WHEREEMPNO=OOO01；
- D、SELECT*FROMEMP；
- E、DROPTABLEEMP；
- F、CREATEINDEXENAME_IDXONEMP（ENAME）；
相关考题：
以下语句错误的是( )A.select sal+1 from emp;B.select sal*10,sal*deptno from emp;C.不能使用运算符号D.select sal*10,deptno*10 from emp;
以下语句不正确的是( )A.select * from emp;B.select ename,hiredate,sal from emp;C.select * from emp order deptno;D.select * from where deptno=1 and sal
以下说法错误的是( )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;
以下插入记录正确的( )A.insert into emp(ename,hiredate,sal) values (value1,value2,value3);B.insert into emp (ename,sal)values(value1,value2,value3);C.insert into emp (ename)values(value1,value2,value3);D.insert into emp (ename,hiredate,sal)values(value1,value2);
Examine the following commands and their output:SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.
UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT，ROLLBACK，oranydatadefinitionlanguage（DDL）command：SQLSELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno；SCOTThasopenedanothersessiontoworkwiththedatabaseinstance.WhichthreeoperationswouldwaitwhenissuedinSCOTT’ssecondsession（）A.LOCKTABLEempINSHAREMODE；B.LOCKTABLEempINEXCLUSIVEMODE；C.UPDATEempSETsal=sal*1.2WHEREjob=ANAGER？UPDATEempSETsal=sal*1.2WHEREjob=？ANAGER？D.INSERTINTOemp（empno，ename）VALUES（1289，’Harry’）；E.SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno
Which two statements complete a transaction? () A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVE POINT C;D. GRANT SELECT ON employees TO SCOTHE. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees WHERE department _ id 20;
The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
emp表是雇员信息表,sal字段存放是的雇员的月薪,以下哪个变量可以存放sal类型的值() A.v_sal emp%rowtype;B.v_sal emp.sal%type;C.v_sal emp.sal.%type;D.v_sal %type(emp.sal);E.v_sal (emp.sal)%type;
取出工资在2000到3000元(包括上下限)之间的员工() A.select * from emp wher sal in (2000,3000);B.select * from emp wher sal like (2000,3000);C.select * from emp wher sal = (2000,3000);D.select * from emp wher sal between 2000 and 3000;
A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1： ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）A、The tempfile belonging to the default temporary tablespace is missing.B、The database is opened in restricted mode， so queries are not allowed.C、The default temporary tablespace required to execute the query is offline.D、The default temporary tablespace required to execute the query is dropped.E、The default temporary tablespace required to execute the query is readonly.
执行如下两个查询，结果为（） Select ename name，sal salary from emp order by salary Select ename name，sal“salary”from emp order by sal ascA、两个查询结果完全相同B、第一个查询正确，第二个查询错误C、两个查询结构不同D、第二个查询正确，第一个查询错误
对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）A、select sal,decode(sal3000,'A',sal2000,'B','C') grade from emp;B、select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;C、select sal,(case when sal3000 then 'A' when sal2000 then 'B' else 'C' end) grade from emp;D、select sal,(if sal3000 then 'A' elsif sal2000 then 'B' else 'C' end if) grade from emp;
Which two statements complete a transaction?（）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVEPOINT C;D、GRANT SELECT ON employees TO SCOTT;E、ALTER TABLE employees SET UNUSED COLUMN sal;F、Select MAX(sal) FROM employees WHERE department_id = 20;
Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）A、No change is required to achieve the desired results.B、SELECT ename, sal, 12* (sal+100) FROM emp;C、SELECT ename, sal, (12* sal)+100 FROM emp;D、SELECT ename, sal +100,*12 FROM emp;
取出工资在2000到3000元（包括上下限）之间的员工（）A、select * from emp wher sal in (2000,3000);B、select * from emp wher sal like (2000,3000);C、select * from emp wher sal = (2000,3000);D、select * from emp wher sal between 2000 and 3000;
The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
Which two statements complete a transaction? （）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVE POINT C;D、GRANT SELECT ON employees TO SCOTHE、ALTER TABLE employees SET UNUSED COLUMN sal;F、Select MAX(sal) FROM employees WHERE department _ id 20;
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 ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
对于以下SQL语句说法正确的是（） SELECT ename FROM emp WHERE sal IN (SELECT MAX(sal) FROM emp GROUP BY deptno);A、这个语句是符合语法的B、这个语句是不能执行的,因为缺少HAVING子句C、这个语句是不能执行的,因为分组的条件列不在SELECT列表中D、这个语句是不能执行的,因为GROUP BY子句应该在主查询中,而不是在子查询中E、在主查询的WHERE条件中,不应该用IN,而应该用等号
单选题执行如下两个查询，结果为（） Select ename name，sal salary from emp order by salary Select ename name，sal“salary”from emp order by sal ascA两个查询结果完全相同B第一个查询正确，第二个查询错误C两个查询结构不同D第二个查询正确，第一个查询错误
单选题Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）ANo change is required to achieve the desired results.BSELECT ename, sal, 12*(sal+100) FROM emp;CSELECT ename, sal, (12*sal)+100 FROM emp;DSELECT ename, sal+100,*12 FROM emp;
多选题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 ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
单选题A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1： ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）AThe tempfile belonging to the default temporary tablespace is missing.BThe database is opened in restricted mode， so queries are not allowed.CThe default temporary tablespace required to execute the query is offline.DThe default temporary tablespace required to execute the query is dropped.EThe default temporary tablespace required to execute the query is readonly.