当前位置:1z0-043题库

问题:

[单选]

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

A .  grant SYSDBA to the user
B .  grant SYSOPER to the user
C .  grant the RESOURCE role to the user
D .  use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E .  grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

对于高等教育心理学的研究来说,应遵循以下哪些原则?() A.客观性原则 。 B.发展性原则 。 C.理论联系实际原则 。 D.教育性原则。 You want to create a temporary table while executing a procedure in a form. Which statement is true?() You cannot create a table form within Forms. 。 You must use the FORMS_DDL built-in to create the table. 。 You must use the DBMS_DYNAMIC_DDL package to create the table. 。 You can write the CREATE TABLE statement directly into the trigger.。 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?() Create the CREATE_TEST procedure with definer’s rights.。 Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.。 Create the CREATE_TEST procedure with invoker’s rights.。 Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.。 广州是隋唐时期“海上丝绸之路”的重要港口,这条“海上丝绸之路”()。 取代陆路“丝绸之路”,成为当时唯一的对外商路。 是通向日本,朝鲜的主要商路。 最远可抵达非洲东海岸。 可到达波斯湾。 反形式主义是()的基本特征。

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

参考答案:

  参考解析

本题暂无解析

在线 客服