单选题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

题目

单选题

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

because of redo data from redo log file

because of data from database buffer cache

because of data from a temporary tablespace

because of undo data from the undo tablespace

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。

A.GRANT CHANGE ON SCOTT.EMP TO SA

B.GRANT UPDATE ON SCOTT.EMP（SAL） TO SA

C.GRANT UPDATE （SAL） ON SCOTT.EMP TO SA

D.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA

参考答案：B

第2题：

授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。

A、GRANT CHANGE ON SCOTT.EMP TO SA
B、GRANT UPDATE ON SCOTT.EMP（SAL） TO SA
C、GRANT UPDATE （SAL） ON SCOTT.EMP TO SA
D、GRANT MODIFY ON SCOTT.EMP（SAL） TO SA

正确答案:B

第3题：

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.

参考答案：C

第4题：

In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；

A、 when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
B、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
D、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

正确答案:C,D

第5题：

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
C、Data is never redacted for the EMP_V.SAL column.
D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

正确答案:A,C

第6题：

The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario（）

A、The session is terminated after receiving the error and JIM can continue with his transaction.
B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C、The session is rolled back after receiving the error and JIM can continue with his transaction.
D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

正确答案:B,D

第7题：

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.

正确答案:D

第8题：

A redaction policy was added to the SAL column of the SCOTT.EMP table:All users have their default set of system privileges.For which three situations will data not be redacted?()

A. SYS sessions, regardless of the roles that are set in the session

B. SYSTEM sessions, regardless of the roles that are set in the session

C. SCOTT sessions, only if the MGR role is set in the session

D. SCOTT sessions, only if the MGR role is granted to SCOTT

E. SCOTT sessions, because he is the owner of the table

F. SYSTEM session, only if the MGR role is set in the session

参考答案：A, D, F

第9题：

You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）

A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

正确答案:A

第10题：

A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）

A、SYS sessions, regardless of the roles that are set in the session
B、SYSTEM sessions, regardless of the roles that are set in the session
C、SCOTT sessions, only if the MGR role is set in the session
D、SCOTT sessions, only if the MGR role is granted to SCOTT
E、SCOTT sessions, because he is the owner of the table
F、SYSTEM session, only if the MGR role is set in the session

正确答案:A,D,F

单选题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

题目

相似问题和答案

更多相关问题

相关内容