试题详情
- 多项选择题 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;
- A,B,E
关注下方微信公众号,在线模考后查看
热门试题
- The database&en
- Given: Whatistheres
- Which statemen
- You work
- Which statement adds
- Which command&
- Which method&en
- You executed
- Which three statemen
- Identify four&
- You create&ens
- Which two partitione
- You have
- Using the LIST comma
- ViewtheExhibittoexam
- Given: What, i
- Note the
- You need to replica
- ViewtheExhibittoexam
- Which statement desc