In your production database， you have multiple resource plan directives that refer to the consumer 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

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 execute even if the active session pool for the new consumer group was full.

相关问题推荐

• You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）

  A、 FILE

  B、 PARFILE

  C、 LOGFILE

  D、 FEEDBACK

  查看答案

• You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  A、 MMAN

  B、 PMON

  C、 MMON

  D、 MMNL

  查看答案

• In which of the following scenarios is a tablespace recovery required？（）

  A、 when recovering a lost read-only tablespace from a read-only tablespace backup

  B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode

  C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten

  D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

  查看答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  A

  SYSDATE should not be used with TIMESTAMP.

  B

  The database must have multiplexed redo log files.

  C

  The database must be in the MOUNT state to execute the command.

  D

  The database must be opened with the RESETLOGS option after the flashback operation.

  E

  The entire database needs to be restored from the most recent backup before the flashback operation.

  查看答案

• In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

  A、REBUILD

  B、CASCADE

  C、TRUNCATE

  D、ROW MOVEMENT

  E、SHRINK SPACE COMPACT

  F、SHRINK SPACE CASCADE

  查看答案