多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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?()

  • A、because of redo data from redo log file
  • B、because of data from database buffer cache
  • C、because of data from a temporary tablespace
  • D、because of undo data from the undo tablespace
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题