试题详情
- 多项选择题 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
- A,B,E
关注下方微信公众号，在线模考后查看
热门试题
- Examinethedescriptio
- You need to give th
- You createQ
- How many
- Which of
- Which of
- 假设需要查询Oracle数据文件的文件名
- Which two statements
- What are three facts
- Which two̳
- Examine the followi
- Which two statements
- To set t
- Examinethefollowingc
- What is true of usin
- ROW-based replicati
- Which Man class prop
- In your d
- Examinethefollowingc
- Which two are functi