下列（）命令在记录上设置了一个或多个排他锁。A、ALTERTABLEEMPADDCOLUMNBIRTHDAY（DATE）；B、UPDATEEMPSETSAL=SAL*1.5+100；C、UPDATEEMPSETSAL=SAL*1.1WHEREEMPNO=OOO01；D、SELECT*FROMEMP；E、DROPTABLEEMP；F、CREATEINDEXENAME_IDXONEMP（ENAME）； - 搜题匠

Oracle

题目

下列（）命令在记录上设置了一个或多个排他锁。

A、ALTERTABLEEMPADDCOLUMNBIRTHDAY（DATE）；
B、UPDATEEMPSETSAL=SAL*1.5+100；
C、UPDATEEMPSETSAL=SAL*1.1WHEREEMPNO=OOO01；
D、SELECT*FROMEMP；
E、DROPTABLEEMP；
F、CREATEINDEXENAME_IDXONEMP（ENAME）；

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

以下语句错误的是( )A.select sal+1 from emp;B.select sal*10,sal*deptno from emp;C.不能使用运算符号D.select sal*10,deptno*10 from emp;

点击查看答案
相关问题 2：

以下语句不正确的是( )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

点击查看答案
相关问题 3：

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

点击查看答案
相关问题 4：

以下插入记录正确的( )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);

点击查看答案
相关问题 5：

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.

点击查看答案
相关问题 6：

UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT，ROLLBACK，oranydatadefinitionlanguage（DDL）command：SQL>SELECTenameFROMempWHEREjob=’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

点击查看答案
相关问题 7：

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;

点击查看答案

相关内容