多项选择题
A. open the database with the RESTRICTED option
B. open the database with the RESETLOGS option
C. recover to the required SCN only that data file in which the error occurred
D. recover all the data files to the same system change number （SCN）
单项选择题 In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）
单项选择题 YounoticedthatlargememoryallocationsfortheOraclebackupandrestoreoperationsarecausingaperformanceoverheadonthesharedpool.Whichmemorystructurewouldyouconfiguretoavoidthisperformanceoverhead？（）
单项选择题 FromtheV$SESSION_LONGOPSview，youfindthatsomeofthedatabaseusershavelong-runningqueriesthatconsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase，whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime，butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis？（）