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
查看答案
2#岩石硝铵炸药的爆速为()多少?
A. 3200米/秒
B. 1600米/秒
C. 6450米/秒
下列可用于抗心律失常的药物是()。
A. 喹尼丁
B. 辛伐他汀
C. 氯贝丁酯
D. 卡托普利
基础油粘度指数低是分馏效果不好造成的。
A. 正确
B. 错误