black

1Z0-042

登录

单项选择题

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

相关考题

单项选择题 Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter:  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command? ()

单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.Youdeterminethatarchivingwasnotsuccessfulinoneofthedestinators.Youwanttocheckthealertlogfileformoreinformationonthis.Whichinitializationparametergivesyouthelocationofthealertlogfile?()

单项选择题 You executed the following command to back up your control file:  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  Which initialization parameter is used to specify the location of the trace file?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064