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。
乙二醇贫液靠()压至乙二醇储罐(大库房处) 液位差。 压力差。
广州是隋唐时期“海上丝绸之路”的重要港口,这条“海上丝绸之路”()。 取代陆路“丝绸之路”,成为当时唯一的对外商路。 是通向日本,朝鲜的主要商路。 最远可抵达非洲东海岸。 可到达波斯湾。
灌注桩施工过程中应对()等进行全过程检查。 成孔。 清渣。 放臵钢筋笼。 灌注混凝土。
Note the functionalities of various background processes: 1:Perform recovery at instance startup. SMON 2:Free the resources used by a user process when it fails. PMON 3:Cleanup the database buffer cache when a process fails. PMON 4:Dynamically register database services with listeners. PMON 5:Monitor sessions for idle session timeout. PMON 6:Cleanup unused temporary segments. SMON 7:Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process() Checkpoint (CKPT): 1, 2, 5。 System Monitor (SMON): 1, 6。 Process Monitor (PMON): 4, 6, 7。 Database Writer (DBWR): 1, 3, 4。
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()