可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

User SCOTT executes th


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 ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session()

  • ALOCK TABLE emp IN SHARE MODE;
  • BLOCK TABLE emp IN EXCLUSIVE MODE;
  • CUPDATE emp SET sal=sal*1.2 WHERE job=MANAGER;
  • DINSERT INTO emp(empno,ename) VALUES (1289,’Harry’);
  • ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、The user SCOTT who&ens

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT...

2、表达式10>5&&6%3的值是()

表达式10>5&&6%3的值是()A-1B非零值C0D1

3、A user executes a&ensp

A user executes a query on the EMP table, which contains thousands of rows, to get ...

4、User A executes the&en

User A executes the following command to drop a large table in your database:SQL> DROP TA...

5、The user SCOTT execute

The user SCOTT executes the following command successfully to increase the salary values in one...

6、User A executes the&en

User A executes the following command to update the TRANS table)  SQL> UPDATE B.trans SET...