违法和不良信息举报 联系客服
免费注册 登录

The user SCOTT e

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?()

A. All the objects of scott are moved to the Recycle Bin.

B. Any objects in the Recycle Bin belonging to scott are purged.

C. All the objects owned by scott are permanently dropped from the database.

D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


参考答案：B, C

第2题：

The DBA issues this SQL command:What privileges does the user Scott have at this point?()

A. No privileges.

B. Only the SELECT privilege.

C. Only the CONNECT privilege.

D. All the privileges of a default user.


参考答案：A

第3题：

在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）

A.ALTER PROFILE USER scott otherprofile

B.ALTER otherprofile USER scottPROFILE

C.ALTER USER scott PROFILE otherprofile

D.ALTER scott USER PROFILE otherprofile


正确答案：C

第4题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

  • A、ALTER DATABASE FLASHBACK ON;
  • B、GRANT SELECT any transaction TO scott;
  • C、GRANT EXECUTE ON dbms_flashback TO scott;
  • D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  • E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
  • F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

正确答案:B,C,D,F

第5题：

在Oracle中，将当前系统所有角色都授予scott，除Payroll外，下列哪个是正确的?()

A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT Payroll

B、ALTER USER DEFAULT ROLLE ALL EXCEPT Payroll

C、ALTER DEFAULT ROLLE ALL EXCEPT USER scott

D、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll


参考答案：D

第6题：

The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()

A. no privileges

B. only the SELECT privilege

C. only the CONNECT privilege

D. all the privileges of a default user


参考答案：A

第7题：

在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）

A.ALTER USER scott IDENTIFIED BY hello

B.ALTER scott USER IDENTIFIED BY hello

C.ALTER USER scott IDENTIFIED AS hello

D.ALTER USER hello IDENTIFIED BY scott


正确答案：A

第8题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT any transaction TO scott;

C. GRANT EXECUTE ON dbms_flashback TO scott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;


参考答案：B, C, 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题：

在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的？（）

  • A、ALTER USER scott DEFAULT TABLESPACE data2_ts
  • B、ALTER DEFAULT TABLESPACE data2_ts USER scott
  • C、ALTER USER scott TABLESPACE DEFAULT data2_ts
  • D、ALTER scott USER DEFAULT TABLESPACE data2_ts

正确答案:A

更多相关问题
相关内容