单项选择题

A.It transfers statistics from memory to disk at regula……

Which statement is true about the Manageability Monitor （MMON） background process（）

A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

<上一题目录下一题>

热门试题

多项选择题WhichtwostatementsaretrueregardingtheSGA_TARGETinitializationparameter（）

A.It can be increased up to the value of the SGA_MAX_SIZE parameter.
B.Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
C.Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
D.Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

多项选择题WhichtwoactivitiesareNOTsupportedbytheDataRecoveryAdvisorDRA（）

A.Recover from failures in the RAC environment.
B.Diagnose and repair a data file corruption online.
C.Diagnose and repair a data file corruption offline.
D.Diagnose and repair failures on a standby database

多项选择题Which operationsrequireundodata（）

A.Committing a transaction
B.Flashing back a transaction
C.Recovering a failed transaction
D.Running a read-consistent query
E.Changing a tablespace status from READ ONLY to READ WRITE

单项选择题You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

A.Archiving will be disabled because the destination for the redo log files is missing.
B.The database instance will shut down and the error details will be logged in the alert log file.
C.Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
D.Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

多项选择题WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLAreas（）

A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.