单项选择题
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgrNUMBER, 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 DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would yousuggest to the PL/SQL developers to achieve this()
A.Create the procedure with definer’s right.
B.Create the procedure with invoker’s right.
C.Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D.Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users
相关考题
-
多项选择题
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror 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 eitherof which will help you resolve this problem. ()
A.Grant the RESOURCE role to SCOTT.
B.Add data files to the USERS tablespace.
C.Grant the CREATE ANY TABLE privilege to SCOTT.
D.Increase the space for SCOTT on the USERS tablespace.
E.Increase the size of the data file associated with the USERS tablespace -
多项选择题
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener()
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two -
单项选择题
View the Exhibit and examine the output of the query. What do you infer from this()
A.The SGA_TARGET is a static parameter.
B.The instance is started, but the database is not yet open.
C.The server parameter file (SPFILE) was used to start the instance.
D.The SGA_TARGET parameter does not have any effect on the database instance until theSGA_MAX_SIZE parameter is specified
