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

The user SCOTT execute


The user SCOTT executes the following command successfully to increase the salary values in one of his sessions:  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20;  Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values.  Why does HR still see the old data?()

  • Abecause of redo data from redo log file
  • Bbecause of data from database buffer cache
  • Cbecause of data from a temporary tablespace
  • Dbecause of undo data from the undo tablespace
参考答案
参考解析:
分类:1Z0-042题库
相关推荐

1、You executed the follo

You executed the following procedure to collect statistics regarding an index:      ...

2、User SCOTT executes th

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROL...

3、The user SCOTT who&ens

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

4、A user executes a&ensp

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

5、User A executes the&en

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

6、User A executes the&en

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