[单选]
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）

A . Create the CREATE_TEST procedure with definer’s rights.
B . Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
C . Create the CREATE_TEST procedure with invoker’s rights.
D . Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

男性，35岁，炼钢工人，工作中不慎被烧伤，烧伤深度诊断为Ⅲ0，烧伤面积达70%，目前应采用隔离措施是（）严密隔离。呼吸道隔离。消化道隔离。接触性隔离。保护性隔离。鸟孩是作家（）塑造的农村拾荒孩子形象。对于高等教育心理学的研究来说，应遵循以下哪些原则？（） A.客观性原则。 B.发展性原则。 C.理论联系实际原则。 D.教育性原则。 You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）； This command errorsout displaying the following message： ERROR at line 1： ORA-01031： insufficient privileges ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（） grant SYSDBA to the user。 grant SYSOPER to the user。 grant the RESOURCE role to the user。 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use。 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package。乙二醇贫液靠（）压至乙二醇储罐（大库房处）液位差。压力差。

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-060题库

相关题目: