User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *  ERROR at line 1：  ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）

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

多选题查看答案

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

多选题查看答案