题目内容

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. 错误

答案查题题库