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

相关问题推荐

• Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

  A、 The user must have been granted the DBA role.

  B、 The user must have been granted the switch privilege as a part of a role.

  C、 The user must have been granted the Resource Manager administrator privilege.

  D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

  查看答案

• You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

  A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

  B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

  C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

  D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

  查看答案

• You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）

  A、 Use ROLLBACK command with SCN 663571.

  B、 Perform Flashback Transaction Query with SCN 663571.

  C、 Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  D、 Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  查看答案

• You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

  A、 The index tablespace contains bitmap indexes.

  B、 The index tablespace contains more than one data file.

  C、 The index tablespace supports only complete recovery.

  D、 The index tablespace is not a dictionary-managed tablespace.

  E、 There is a dependency relationship between a table and its indexes.

  查看答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

  A

  You must ensure that the SALES database is mounted or open.

  B

  You must restore a backup control file to perform a block media recovery.

  C

  You must take the tools01.dbf data file offline before you start a block media recovery.

  D

  You must put the database in NOARCHIVELOG mode to perform a block media recovery.

  E

  You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

  查看答案