User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work

题目

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）

A、LOCK TABLE emp IN SHARE MODE；
B、LOCK TABLE emp IN EXCLUSIVE MODE；
C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

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

相似问题和答案

第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题：

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

第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题：

在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

第10题：

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

User SCOTT executes&e

题目

相似问题和答案

更多相关问题

相关内容