单项选择题
A. back up the control file to trace
B. bring database to the MOUNT state
C. open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D. set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
单项选择题 A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal； SELECT ename FROM emp WHERE deptno=10 ORDER BY sal ERROR at line 1： ORA-01157： cannot identify/lock data file 201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）
多项选择题 You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100. Which two statements are correct in this scenario？（）
单项选择题 Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.Yoususpectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）