多项选择题
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；
单项选择题 The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this（）
单项选择题 You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Whichstatement is true after you recompile the EMP_ADMIN package body（）
多项选择题 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.（）