Exhibit，View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）

A

 The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.

B

 The members of SYS_GROUP would get most of the CPU allocation at level 1.

C

 The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.

D

 The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2.

E

 The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.

相关问题推荐

• You have issued the following command：    RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS；   What will be the result of using the above command？（）

  A、 The backup metadata will be maintained in the control file for 100 days.

  B、 The backup metadata will be maintained in the recovery catalog for 100 days.

  C、 The backup metadata will be maintained in the flash recovery area for 100 days.

  D、 After 100 days， the backup sets and image copies will be deleted from the media.

  查看答案

• Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

  A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.

  B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

  C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

  D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

  查看答案

• You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

  A、 You must enable the block change tracking feature.

  B、 You must have enable the flashback feature.

  C、 You must use the OMF in your database.

  D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

  查看答案

• You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

  A、 The archived redo logs are stored in an operating system-dependent location.

  B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

  C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

  D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

  查看答案

• 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.

  查看答案