单项选择题

A.because of redo data from redo log fileB.because of d……

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？（）

A.The command would return an error because LOG_BUFFER is a static parameter.
B.The parameter value would be changed and it would come into effect immediately.
C.You need to restart the database so that parameter changes can come into effect.
D.The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youdeterminethatarchivingwasnotsuccessfulinoneofthedestinators.Youwanttocheckthealertlogfileformoreinformationonthis.Whichinitializationparametergivesyouthelocationofthealertlogfile？（）

A.USER_DUMP_DEST
B.CORE_DUMP_DEST
C.ALERT_LOG_DEST
D.ALERT_DUMP_DEST
E.TRACE_DUMP_DEST
F.BACKGROUND_DUMP_DEST

单项选择题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？（）

A.USER_DUMP_DEST
B.CORE_DUMP_DEST
C.TRACE_DUMP_DEST
D.BACKUP_DUMP_DEST
E.BACKGROUND_DUMP_DEST

单项选择题The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）

A.HR can grant the privilege to JIM but without GRANT OPTION.
B.HR can grant the privilege to JIM because HR is the owner of the view.
C.SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D.HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

多项选择题Datafilesofwhichthreetablespacescanberecoveredbyperforminganopenrecovery？（）

A.TEMP
B.UNDO
C.INDEX
D.SYSAUX
E.SYSTEM