Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. 
What would you do to recover the data file（）

单项选择题Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario()

A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

单项选择题WhichstatementistrueabouttheManageabilityMonitor（MMON）backgroundprocess（）

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