单项选择题
A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically
单项选择题 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 errors out displaying the following message： ERROR at line 1： ORA-29371： pending area is not active 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？（）
单项选择题 YouneedtocreateaschedulethatwillrunajobonthesecondFridayofeachmonth.Whatshouldtherepeatintervaloftheschedulebesetto？（）
多项选择题 You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）