In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）

A

 The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

B

 The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

C

 The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

D

 If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

E

 Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

相关问题推荐

• You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

  A、 flash back the corrupted blocks

  B、 use the DBMS_REPAIR package

  C、 use the RMAN TSPITR command

  D、 use the RMAN BLOCKRECOVER command

  E、 use the RESTORE DATABASE and RECOVER DATABASE commands

  F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

  查看答案

• public class Yippee {  public static void main（String [] args） {  for（int x = 1； x 

  A、 No output is produced. 123

  B、 No output is produced. 234

  C、 No output is produced. 1234

  D、 An exception is thrown at runtime. 123

  E、 An exception is thrown at runtime. 234

  F、 An exception is thrown at rijntime. 1234

  查看答案

• Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

  A、 V$DATABASE

  B、 V$UNDOSTAT

  C、 V$FLASHBACK_DATABASE_LOG

  D、 V$FLASHBACK_DATABASE_STAT

  查看答案

• Your SPFILE contains the following parameter settings：   SGA_TARGET = 8G   DB_CACHE_SIZE = 4G   SHARED_POOL_SIZE = 2G   LARGE_POOL_SIZE = 512M   JAVA_POOL_SIZE = 512M   LOG_BUFFER = 100M   SGA_MAX_SIZE = 10G   You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH；   What is the result of this statement？（）  

  A、 The database crashes.

  B、 The large pool releases 512M of memory.

  C、 The large pool retains 1G of allocated memory.

  D、 The large pool increases to 1，512M of memory.

  查看答案

• 下列选项中不符合良好程序设计风格的是()。

  A．源程序要文档化

  B．数据说明的次序要规范化

  C．避免滥用goto语句

  D．模块设计要保证高耦合、高内聚

  查看答案