多选题

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()

ALOCK TABLE emp IN SHARE MODE;

BLOCK TABLE emp IN EXCLUSIVE MODE;

CUPDATE emp SET sal=sal*1.2 WHERE job=MANAGER;

DINSERT INTO emp(empno,ename) VALUES (1289,’Harry’);

ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

正确答案

来源:www.examk.com

答案解析

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

    多选题查看答案

  • You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code:        SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP  (’SCOTT’,       ’GRP1’, FALSE);   How will you grant the switch privilege to the user, Scott?()  

    单选题查看答案

  • View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr;  Which statement describes the outcome of the command() 

    单选题查看答案

  • The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:  SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;  Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()

    单选题查看答案

  • User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger  directory = EXPORT_DIR  dumpfile = scott.dmp include = table  include = view:"like ’%DEPARTMENTS%’"  content = DATA_ONLY  Which task would the command accomplish?()

    单选题查看答案

  • View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command()

    单选题查看答案

  • 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?()

    单选题查看答案

  • 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()

    多选题查看答案

  • User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session()

    多选题查看答案